DB_TRIG

Represents information of the trigger that has the class for which the current user has access authorization in the database, or its attribute as the target.

Example

• The following is an example of showing information of the trigger that has the class for which the current user has access authorization, or its attribute as the target.

CREATE VCLASS db_trig (

trigger_name, target_class_name, target_attr_name, target_attr_type, action_type, action_time)

AS

SELECT CAST(t.name AS VARCHAR(255)), c.class_name,

        CAST(t.target_attribute AS VARCHAR(255)),

        CASE WHEN t.target_class_attribute = 0 THEN 'INSTANCE' ELSE 'CLASS' END,

        t.action_type, t.action_time

FROM _db_class c, db_trigger t

WHERE t.target_class = c.class_of AND

        (CURRENT_USER = 'DBA' OR

        {c.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

        {c} 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'));

• The following is an example of retrieving trigger information of the class.

csql> select target_class_name, trigger_name

csql> from db_trig

csql> order by 1;

csql> ;xrun

=== <Result of SELECT Command in Line 1> ===

target_class_name     trigger_name

============================================

  'glo'               'glo_delete_contents'