The SYSROLEGRANTS system view stores information about role membership and type of membership, just like the SYSROLEGRANT system view does. However, SYSROLEGRANTS includes role names and grantee names (not just IDs). The underlying system tables for this view are ISYSROLEGRANT and ISYSUSER.
|Column name||Data type||Description|
|grant_id||UNSIGNED INT||ID used to identify each GRANT statement.|
|role_id||UNSIGNED INT||ID of the role being granted, as per ISYSUSER.|
|role_name||CHAR(128)||The name of the role.|
|grantee||UNISIGNED INT||ID of the user being granted the role, as per ISYSUSER.|
|grantee_name||CHAR(128)||The name of the grantee.|
Describes type of grant using 3 bits. The first bit from the right is whether privilege has been granted. The second digit is whether administration rights have been given. The third digit is whether system privileges are inheritable.
Used by SET USER and CHANGE PASSWORD to set the scope of the grant. Values can be one or more of the following:
|grantor||CHAR(128)||The name of the grantor.|
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|