| Invoker Rights [message #169318] |
Wed, 26 April 2006 04:40  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
