Manage Authorities

Grant database authorities to a user or group, and revoke database authorities from a user or group.

For detailed information on using database authorities in Sybase IQ, see System Administration Guide: Volume 1 > Managing User IDs and Permissions > Database Permissions and Authorities Overview.

Members of a group can inherit the following authorities set for the group they belong to:

READCLIENTFILE
READFILE
WRITECLIENTFILE
DBA
RESOURCE
OPERATOR
MULTIPLEX ADMIN
PERMS ADMIN
SPACE ADMIN
USER ADMIN

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.
Revoking an Authority from a User or Group
Revoke an authority to remove a user's or group's ability to perform specified database operations.

Parent topic: Manage Sybase IQ Security