Home » RDBMS Server » Security » Regarding PAckage security
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,






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


Current Time: Thu Mar 28 06:58:03 CDT 2024