Grant a compatibility role to a user or role. Normally, you grant compatibility roles to maintain backwards compatibility.
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:
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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|