_db_auth

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:

Example

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'