Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Roles » Compatibility roles

 

Granting a compatibility role (Sybase Central)

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

Prerequisites

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

Context and remarks

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
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the Roles folder, click the compatibility role you want to grant.

  3. In the right pane, click Grantees.

  4. Right-click anywhere in the right pane and choose New » Grantees.

  5. 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.

  6. Click File » Save.

Results

The compatibility role is granted to the user or role.

 See also