Command Window can't VIEW Package object from Debug Readonly USER

Smartree

Member

Command Window can't VIEW Package object by a user who have only Debug(Readonly) on the Packages.

for example:
grant DEBUG on A.FUNC_PKG to B;

open PL/SQL Developer with B user,
Command window can not VIEW A.FUNC_PKG,
Object window CAN View A.FUNC_PKG

open SQLPLUS with B user,
CAN desc A.FUNC_PKG

How can i VIEW A.FUNC_PKG in Command window?
 
if grant SO the user B will be not a ReadOnly user.
we didn't want the user B edit package or procedure.

and now,
in Command Window:
B can View A.Table

in Objects Window:
user B can View A.Table
user B can View A.Package

we only grant select on A.Table to B;
 
Last edited:
Back
Top