The SYSROLEGRANT system view stores information about role membership and type of membership. The underlying system table for this view is ISYSROLEGRANT.
|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.|
|grantee||UNISIGNED INT||ID of the user being granted the role, as per ISYSUSER.|
Describes type of grant using 3 digits. 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|