Home » RDBMS Server » Security » Regarding PAckage security
Regarding PAckage security [message #160252] Fri, 24 February 2006 01:51
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;
> 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.

Previous Topic: how to extent the expiry_date
Next Topic: why sys when connected as sysdba
Goto Forum:

Current Time: Sun May 22 12:58:28 CDT 2022