sql_trace的权限
sql_trace的权限
我用dba的帐户创建了一个触发器
CREATE OR REPLACE TRIGGER logon_trg
after logon on database
begin
if user='TEST' then
execute immediate
'alter session set events ''10046 trace name context forever,level 4''';
end if;
end;
然后,我用TEST帐户登陆数据库,提示
ERROR:
ORA-00604:error occurred at recursive sql level 1
ORA-01031:insufficaient privileges
ORA-06512:at line 3
我已经授予TEST帐户CONNECT,CREATE SESSION,ALTER SESSION
权限,而且如果禁用触发器,登陆后可以执行 ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER,LEVEL 4'
显示会话更改成功,那么要让触发器能正常运行,要赋予TEST什么权限呢?