Re: DB Event Triggers - Run as Who?

> I suppose I could do some testing but perhaps someone can give me the quick
> answer. My question regards object ownership rules against trigger
> ownership. When a database shutdown trigger runs, who does it run as? The
> person performing the shutdown or SYS or the person that owns it. When a
> logon trigger runs does it run as the user who owns the trigger or the
> person logging in? Does the person logging in need permission to run FOO
> from SCOTT? What if I select into a variable using V$MYSTAT, who's info
> will I get? You get the idea. Now I will go read the docs, but if you get
> a chance I would appreciate a reply.

Well, at least I hope that the trigger runs with the permission of the person who owns it. If not it'd be a huge security hole and I'll get a different rdbms.

Regards,

Knut Received on Fri Oct 12 2001 - 07:47:20 CDT