Restores a compatibility role that has been migrated or dropped. This method cannot be used to restore any other kinds of roles.
You must have the MANAGE ROLES system privilege and have administrative rights on all of the system privileges granted to the role being restored. For example, to restore the SYS_AUTH_BACKUP_ROLE compatibility role, you must have the MANAGE ROLES system privilege, and administrative rights on the BACKUP DATABASE system privilege.
Context and remarks
You can restore compatibility roles that are no longer in the database. Restoring one of these roles can be helpful to remember the privileges the original role had or to migrate them to user-defined roles.
If you migrated the compatibility role (causing it to be dropped), grantees of the role were automatically granted the new user-defined role you migrated it to. Restoring a compatibility role does not restore the grantees back to the compatibility role. They remain grantees of the user-defined role you created.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Roles.
In the right pane, right-click anywhere in the pane and click New » Roles.
Click Restore one or more compatibility roles in the Create Role Wizard and follow the instructions.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|