| Regarding PAckage security [message #160252] |
Fri, 24 February 2006 01:51 |
mahesh.vadamudula
Messages: 7
Registered: February 2006
Location: vizag
|
Junior Member |
|
|
hi all,
i 've one prob.
i ve 2 users u1 and u2.
u1 has created one package called MyPkg.
and now u1 has granted EXECUTE privilge on the package to u2.
as >grant execute on MyPkg to u2;
Now my question as User "u2" i want to see the package body
of MyPkg of user u1.
if that is the case then what privilge does the u1 must grant
to user u2.
I logged in as u2 and tried as follows.
spool c:\pkg
>select distinct object_type from all_source;
and
> select text from all_source;
From the above query i can able to see only the package
specification.
But my requiremnt is as user "u2" i must able to see the
source of package body created by u1.
then what privilege u1 should have granted to u2 is my question.
Waiting for a sincere reply.
Regards,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
