Inheriting authorities

Table 8-1 lists the authorities that you can assign to users, and whether they are inherited through group membership.

**Table 8-1: 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 “MULTIPLEX ADMIN authority overview” in Chapter 2, “Managing Multiplex Servers,”in Using Sybase IQ Multiplex.

Some of the authorities listed in Table 8-1 are provided by SQL Anywhere. See "Authorities overview" in SQL Anywhere Server – Database Administration. See “Authorities overview” for details about authorities that Sybase IQ provides.

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.