Granting a compatibility role (Sybase Central)

Grant a compatibility role to a user or role. Normally, you grant compatibility roles to maintain backwards compatibility.

Prérequis

You must have administrative rights over the compatibility role you are granting.

Contexte et remarques

When you grant a compatibility role to a role, the compatibility role's system privileges are available to both the role and its grantees. However, you can disable the inheritance of the system privileges for the following compatibility roles:

SYS_AUTH_DBA_ROLE
SYS_AUTH_RESOURCE_ROLE
SYS_AUTH_BACKUP_ROLE
SYS_AUTH_VALIDATE_ROLE

In Sybase Central, when you grant one of these compatibility roles to a user-extended role or a system role, the inheritance of the system privileges is disabled by default. Disabling system privilege inheritance for a compatibility role mimics the behavior of the non-inheritable authority in version 12 and earlier databases.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the Roles folder, click the compatibility role you want to grant.
In the right pane, click Grantees.
Right-click anywhere in the right pane and choose New » Grantees.
Click the user or role you want to grant the compatibility role to and then click OK.

A new row is added in Grantees.

If the inheritance of the system privileges for the compatibility role is disabled, then the Options column contains Inheritance disabled. To enable the inheritance of the system privileges, right-click the row, click Set Options, and choose Enable system privilege inheritance.

With the exception of granting the SYS_AUTH_DBA_ROLE compatibility role, you cannot grant administrative rights if the Inheritance disabled is selected.
Click File » Save.

Résultat

The compatibility role is granted to the user or role.

Granting a compatibility role (Sybase Central)

Task

See also