Re: Q: How to see another users pkg-bodies without dba-role

"Reinhard" <Reinhard_nospam.Wahl_at_gmx.de> wrote in message news:<a5ica0$7g33j$1_at_ID-119204.news.dfncis.de>...
> Hi,
>
> what privilege does user A need to see the sources of the package bodies of
> user B if he has no dba-rights?
> I tried some of the privileges of the dba-role, but there are to many and
> user A has to reconnect every time again because ORACLE seems to remember
> the rights from the last login.
>
> Does anyone know the decisively privilege?
> Regards
> Reinhard
> --------------------------------------------------------------
> For direct reply please remove _nospam from address

If you can execute the package you have select privilege on its source in the all_source dictionary view.

If you are not familar with the rdbms dictionary you might want to review the following articles:

How do I find information about a database object: table, index, constraint, view, etc... in Oracle ?
at url http://www.jlcomp.demon.co.uk/faq/privileges.html

And for security related information

How do I find out which users have the rights, or privileges, to access a given object ?
at url http://www.jlcomp.demon.co.uk/faq/object_info.html

HTH
-- Mark D Powell -- Received on Wed Feb 27 2002 - 09:23:32 CST