Home » SQL & PL/SQL » SQL & PL/SQL » definers rights
definers rights [message #394860] Mon, 30 March 2009 10:57 Go to next message
Messages: 251
Registered: May 2008
Senior Member
the schemas involved are u, rp and pf.

i have a proc u.proc which has has insert into rp.table statement

i gave the following

grant execute on u.proc to pf;

do I also have to grant insert on rp.table to pf ?

please advice

I think..

default is authid definer, and there is no authid current_user in my proc

so which means i am good just by giving the following

grant execute on u.proc to pf;

no need for an insert privilege to pf on rp.table..

correct ?

Re: definers rights [message #394878 is a reply to message #394860] Mon, 30 March 2009 12:24 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
As long as u has (direct, not through a role) the privilege to insert into rp.table, you're fine.
Previous Topic: Effective spooling method
Next Topic: Building a list of dates
Goto Forum:

Current Time: Tue Aug 22 19:50:33 CDT 2017

Total time taken to generate the page: 0.10760 seconds