会话修改触发器? [英] Session Modification Trigger?

问题描述

我有一个Oracle登录触发器，在其中执行了一些alter session语句.我想知道如果用户进行更改会话"是否可以抓住另一个触发器?

I have a Oracle logon trigger where some alter session statements are executed. I am wondering if I can catch with another trigger if the user do a "alter session"?

CREATE OR REPLACE TRIGGER CI_LOGON AFTER LOGON ON DATABASE
BEGIN
   execute immediate 
     'ALTER SESSION SET PLSQL_WARNINGS=''ENABLE:ALL'',''DISABLE:06015''';

   execute immediate
     'ALTER SESSION SET PLSQL_DEBUG = true';

EXCEPTION
   WHEN OTHERS THEN
      NULL;
END;


SQL> show parameters plsql

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
plsql_ccflags                        string
plsql_code_type                      string      INTERPRETED
plsql_debug                          boolean     TRUE
plsql_optimize_level                 integer     2
plsql_v2_compatibility               boolean     FALSE
plsql_warnings                       string      ENABLE:ALL, DISABLE:  6015
SQL>
SQL> ALTER SESSION SET PLSQL_DEBUG = false;

SQL> show parameters plsql

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
plsql_ccflags                        string
plsql_code_type                      string      INTERPRETED
plsql_debug                          boolean     FALSE
plsql_optimize_level                 integer     2
plsql_v2_compatibility               boolean     FALSE
plsql_warnings                       string      ENABLE:ALL, DISABLE:  6015

谢谢 基督徒

推荐答案

不要这样，但是您可以针对

Don't think so, but you could run regular checks against ALL_PLSQL_OBJECT_SETTINGS

您可能还想跟踪谁正在使用其他DDL触发器来更改程序包/过程等.

You might also want to keep track of who is altering packages/procedures etc with some other DDL triggers.

这篇关于会话修改触发器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！