Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

_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:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • ALTER
  • INDEX
  • EXECUTE
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'