|Regarding PAckage security [message #160252]
||Fri, 24 February 2006 01:51
Registered: February 2006
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.
>select distinct object_type from all_source;
> select text from all_source;
From the above query i can able to see only the package
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.