|
-
Hi
First thing is if you execute ur code making a minor change in the code which I done it for you
create or replace trigger sys_test
after logon on sys.schema
begin
null;
end;
this code is fine only change I have made is I have made sys to sys.schema the .schema has to be explictily stated.when you execute the above trigger you will still end with an error it will give you a error stating that
system trigger cannot be defined on the schema of sys user
so try the above code as follows on a different user let take scott as the user it will work for example
create or replace trigger sys_test
after logon on scott.schema
begin
null;
end;
Remember .schema is a must
Regards
[Edited by santoshym on 05-16-2001 at 02:36 PM]
Santosh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|