Grant authorities to allow a user or group to perform specified database operations, such as the ability to manage dbspaces.
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. |