SQL> create user test identified by oracle;
User created.
SQL> grant connect,resource to test;
Grant succeeded.
SQL> conn test/oracle
ERROR:
ORA-04098: trigger 'SYS.TEST' is invalid and failed re-validation
dingjun123 发表于 2011-11-8 11:29
有个logon trigger
SQL> select count(*) from user_source where type='TRIGGER';
COUNT(*)
----------
178
SQL> create user test4 identified by test4;
User created.
SQL> grant connect,resource to test4;
Grant succeeded.
SQL> select count(*) from user_source where type='TRIGGER';
COUNT(*)
----------
178
SQL> conn test4/test4
Connected.
我怎么没有这个trigger，求教？
