| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: triggers: accessing tables from separate schemas
A copy of this was sent to Jackie Marino <Jackie.A.Marino_at_wgp.twc.com>
(if that email address didn't require changing)
On Thu, 28 May 1998 21:18:00 GMT, you wrote:
>Hi:
>
>I am having a problem updating a table in my schema when data is
>entered into another girl's schema from within a trigger. Does
>anyone have ideas on how to get around this?
>Thanks,
>Jackie
>Williams Gas Pipelines
roles are never enabled during the execution of a stored object like a view/procedure/trigger.
Try this:
SQL> set role none;
SQL> "statement you want to test to see if it'll work in a procedure"
If you can do it in plus with no roles you can do it in a procedure. If you can't, you must have the privelege from a role and hence won't be able to do it in a stored object.
You probably have the privelege to do what you are trying to do via a role. Grant the privelege directly to the owner of the object and it'll work.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu May 28 1998 - 20:25:16 CDT
 |
 |