Authority-Based Groups

Add, change, and delete authority-based groups containing users and/or other groups.

Both users and groups are objects within the database. Groups are also containers for containing users and other groups. Think of a group as a user ID with special permissions, such as the ability to have members. You grant and revoke authorities for a group in exactly the same manner as you do for users.

For most databases, manage authorities by using groups, rather than by assigning authorities to individual users one at a time.

• Creating an Authority-Based Group
  Add a new group to the database using the Create Group wizard.
• Deleting an Authority-Based Group
  Delete a group from the database.
• Converting an Authority-Based Group to a User
  Change an existing group into a user.
• Adding Authority-Based Users and Groups to Groups
  Add users and group to the current group or a higher-level parent group.
• Removing Authority-Based Users or Groups from a Group
  Remove users and groups from the current group or a higher-level parent group.
• Viewing or Modifying Authority-Based Group Options
  View or change database option settings assigned to a group.
• Generating Authority-Based Group DDL Commands
  Display the SQL data description language for creating a group. The SQL code can be a useful reference and training tool.
• Viewing or Modifying Authority-Based Group Properties
  View or change the details of login parameters and authorities for a group.
• Adding an Authority to a Group
  Add authorities to allow members of a group to perform specified database operations, such as the ability to manage dbspaces.
• Removing an Authority from a Group
  Remove a group's ability to perform specific authorized database operations.
• Authority-Based Group Privilege Summary
  A list of the system privileges and object permissions required to complete the various authority-based group tasks.