Granting an Authority to a User or Group

Grant authorities to allow a user or group to perform specified database operations, such as the ability to manage dbspaces.

1. In the Perspective Resources view, select a resource.
2. From the application menu bar, select View > Open > Administration Console.
3. In the left pane of the Administration Console, select Security > Users or Security > Groups.
4. Select the user or group from the right pane and either:
   • Click the arrow to the right of the name and select Properties, or
   • From the Administration Console menu bar, select Resource > Properties
5. Click the Authorities tab.
6. Select the authorities you want to assign to the user or group:

   Option	Description
   Backup	Allows this user or group to back up the database.
   DBA	Grants DBA authority to administer the database.
   Multiplex Admin	Grants Multiplex Admin authority to the user or group; a user or group with Multiplex Admin authority can perform multiplex administration tasks.
   Operator	Grants Operator authority to the user or group; a user or group with Operator authority can checkpoint databases, drop connections, backup databases, and monitor the system.
   Perms Admin	Grants Perms Admin authority to the user or group; a user or group with Perms Admin authority can manage data permissions, groups, authorities, and passwords.
   Profile	Allows this user or group to perform application and procedure profiling, and request log creation, and analysis. Profile authority is also required by the index consultant.
   Read client file	Allows this user or group to read from a file on the client computer.
   Read file	Grants Read file authority to the user or group, allowing the user or group to execute SELECT statements against a file using the OPENSTRING clause.
   Remote DBA	Grants Remote DBA authority to any table the user or group can have access to. To ensure that actions are secure, run the SQL Remote Message Agent using a user ID with this type of authority.
   Resource	Grants resource authority to the user or group; a user or group with resource authority can create database objects.
   Space Admin	Grants Space Admin authority to the user or group; a user or group with Space Admin authority can manage dbspaces.
   User Admin	Grants User Admin authority to the user or group; a user or group with User Admin authority can manage users, external logins, and login policies.
   Validate	Allows this user or group to validate tables, materialized views, and indexes.
   Write client file	Allows this user or group to write to a file on the client computer.

7. Click Apply.
8. Click OK.