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: drop and create index partition [merged]
Next Topic: Converting long datatype to its equivalent
Goto Forum:

Current Time: Fri Oct 28 03:39:44 CDT 2016

Total time taken to generate the page: 0.11041 seconds