赋给它权限 connect internal/oracle grant select on v$sql to username; connect username/pw create or replace trigger system.rt_aaa_insert after insert on system.aaa for each row .......
conn sys/.... grant select on v_$sql to yourusername;
我用interval/oracle登陆, grant select on v$sql to system错误: grant select on v$sql to system * 错误位于第1行: ORA-02030: 只能从固定的表/视图查询grant select on sys.v$sql to system也一样我执行触发器是用system登陆的
4/1 PL/SQL: SQL Statement ignored
4/39 PLS-00201: 必须说明标识符'SYS.V$SQL'我在v$sql前加入sys. 错误同上。
connect internal/oracle
grant select on v$sql to username;
connect username/pw
create or replace trigger system.rt_aaa_insert
after insert on system.aaa
for each row
.......
grant select on v_$sql to yourusername;
grant select on v$sql to system错误:
grant select on v$sql to system
*
错误位于第1行:
ORA-02030: 只能从固定的表/视图查询grant select on sys.v$sql to system也一样我执行触发器是用system登陆的