Inheriting Authorities

Some authorities are inherited through group membership.

Authorities
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 Server - Database Administration > Configuring your database > Managing user IDs, authorities, and permissions > Authorities overview.

Note: This reference points to SQL Anywhere documentation.

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.