Change a user to a user-extended role, which can then be granted to other users and roles. User-extended roles are convenient when you have a user with a desired set of system privileges and roles that you also want to grant to another user.
You must have the MANAGE ROLES system privilege.
Contexte et remarques
You can specify administrators for the role during the conversion. If you do not specify administrators, by default any user with MANAGE ROLE system privilege can administer the role.
The user being extended to be a user-extended role cannot be specified as an administrator, nor be granted administrative rights over the role after the conversion is complete. However, if the user being extended has the MANAGE ROLES system privilege, and no administrators are specified at conversion time, then they can administer the role.
Connect to the database.
Execute a CREATE ROLE statement similar to the following:
|Extended the user to be a role that any user with the MANAGE ROLES system privilege can administer.||
|User is extended to a role that any user in list-of-administrator-ids can administer.||
The following statement extends user JaneSmith to become a role that can be assigned to others.
CREATE ROLE FOR USER JaneSmith;
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|