Home » Other » Training & Certification » Invoker Rights
Invoker Rights [message #169318] Wed, 26 April 2006 04:40 Go to next message
ssrividhya
Messages: 8
Registered: April 2006
Junior Member
Two users exist on an Oracle8i system, named FLUFFY and MUFFY.
MUFFY owns a PL/SQL procedure called foobar( ), defined as follows:
create procedure FOOBAR
authid current_user is
var1 number;
begin
select * into var1 from foo;
end;
To use procedure foobar( ), what privileges does FLUFFY need granted to
her (choose as many as appropriate)?
A. create procedure on schema MUFFY
B. execute on procedure foobar( )
C. update on table FOO
D. select on table FOO

Re: Invoker Rights [message #170138 is a reply to message #169318] Tue, 02 May 2006 05:32 Go to previous message
ksmbabu
Messages: 9
Registered: April 2006
Location: MALAYSIA
Junior Member
For this invoker rights we need to create some steps so that fluffy can use the foobar procedure

first you create a role on fluffy.
grant the role to fluffy
grant dml stmt on fluffy

now fluffy can access the foobar() procedure

babu
Previous Topic: ORACLE Training @ Q-Soft Bangalore (India) & Mumbai (India)
Next Topic: entry level jobs in oracle
Goto Forum:
  


Current Time: Thu Mar 28 09:02:46 CDT 2024