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.

Related concepts
Authorities Overview