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_METH_FILE

Represents information of a file in which the method of the class for which the current user has access authorization in the database is defined.

Attribute Name

Data Type

Description

class_name

VARCHAR(255)

Name of the class to which the method file belongs

path_name

VARCHAR(255)

File path in which the C function is defined

from_class_name

VARCHAR(255)

Name of the super class in which the method file is defined if the method is inherited, and otherwise NULL

Definition

CREATE VCLASS db_meth_file (class_name, path_name, from_class_name)

AS

SELECT f.class_of.class_name, f.path_name, f.from_class_of.class_name

FROM _db_meth_file f

WHERE (CURRENT_USER = 'DBA' OR

              {f.class_of.owner.name} subseteq (

                              SELECT set{CURRENT_USER} + coalesce(sum(set{t.g.name}), set{})

                              from db_user u, table(groups) as t(g)

                              where u.name = CURRENT_USER ) OR

              {f.class_of} subseteq (

SELECT sum(set{au.class_of})

                              FROM _db_auth au

                              WHERE {au.grantee.name} subseteq (

                                                      SELECT set{CURRENT_USER} + coalesce(sum(set{t.g.name}), set{})

                                                      from db_user u, table(groups) as t(g)

                                                      where u.name = CURRENT_USER ) AND

                                                                      au.auth_type = 'SELECT'))