Re: Permissions on stored code

From: Summit <noreply_at_noreply.us>
Date: Wed, 07 Jan 2004 17:25:37 GMT
Message-ID: <liXKb.4876$nC.2697@nwrddc01.gnilink.net>

"Winston Chalk" <winston_at_chaseits.co.uk> wrote
> Is it possible to grant privileges that allow users to view the stored
> code and triggers in another user's schema?
>
> The case in point:
>
> We have an Oracle 8i test database where developers are restricted and
> are not allowed to have DBA privileges.
>
> The applications tables and stored code are stored in a schema called
> e.g. APPLICATION. The developers log in with their own user id e.g.
> DEVELOPER and can select from tables etc in the APPLICATION schema via
> public synonyms and grants.
>
> I would like to allow the developers to have read only access to the
> stored code and triggers in the application schema. Please could you
> advise how to do this.

Grant them select on sys.dba_source and sys.dba_triggers and they will have read-only access to the code. Received on Wed Jan 07 2004 - 11:25:37 CST