Some authorities are inherited through group membership.
Authority |
Inherited through group membership |
|---|---|
BACKUP |
No |
DBA |
No |
MULTIPLEX ADMIN |
Yes |
OPERATOR |
Yes |
PERMS ADMIN |
Yes |
PROFILE |
Yes |
READCLIENTFILE |
Yes |
READFILE |
Yes |
REMOTE DBA |
No |
RESOURCE |
No |
SPACE ADMIN |
Yes |
USER ADMIN |
Yes |
VALIDATE |
No |
WRITECLIENTFILE |
Yes |
For MULTIPLEX ADMIN authority, see Using Sybase IQ Multiplex.
Some of the authorities are provided by SQL Anywhere. See SQL Anywhere 11.0.1 > SQL Anywhere Server - Database Administration > Configuring Your Database > Managing user IDs, authorities, and permissions > Database permissions and authorities overview > Authorities overview.
Granting or revoking the authorities MULTIPLEX ADMIN, OPERATOR, PERMS ADMIN, SPACE ADMIN, USER ADMIN on a database created in versions earlier than Sybase IQ 15.2 returns the error code -1347:
Use of authority '%1' is not supported on this current database.