Manage Groups

You can grant permissions to groups to access database objects.

The database owner grants and revokes group encryption permissions.

When SAP ASE is configured to restrict decrypt permission, only the system security officer can grant decrypt permission on tables, columns, and views. When restricted decrypt permission is turned off, the system security officer or the database owner can grant decrypt permission.

Command permissions allow the group to execute create commands. Database owners can assign command permissions to groups in the databases they own.

• Creating a Group
  Create a group in a database.
• Adding or Removing Users to or from a Group
  Add users to a group, look at the users who belong to a group, or remove users from a group.
• Group Properties
  Use the Group Properties window to assign users to a group and change command or object permissions.
• Setting Command Permissions for a Group
  Grant or revoke command permissions to or from a group.
• Granting Object Permissions to a Group
  Grant database object permissions to a group.
• Revoking Object Permissions from a Group
  Revoke database object permissions from a group.
• Granting Privileges to a Group
  Grant system privileges to groups at the server or database level.
• Revoking Privileges from a Group
  Revoke system privileges from groups.
• Deleting a Group
  Use SAP Control Center to delete groups.
• Generate DDL for a Group
  Use SAP Control Center to generate a DDL script for groups.