Represents user authorization information of the class. An index for the grantee is created.
Attribute Name |
Data Type |
Description |
---|---|---|
grantor |
db_user |
Authorization grantor |
grantee |
db_user |
Authorization grantee |
class_of |
_db_class |
Class object to which authorization is to be granted |
auth_type |
VARCHAR(7) |
Type name of the authorization granted |
is_grantable |
INTEGER |
1 if authorization for the class can be granted to other users, and 0 otherwise. |
Authorization types supported by CUBRID are as follows:
The following example shows how to retrieve authorization information defined in the class 'db_trig'.
SELECT grantor.name, grantee.name, auth_type
FROM _db_auth
WHERE class_of.class_name = 'db_trig';
grantor.name grantee.name auth_type
==================================================================
'DBA' 'PUBLIC' 'SELECT'