Read only access to Packages SOurce COde

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 1 Nov 2004 10:56:10 -0800 (PST)
Message-ID: <20041101185610.33920.qmail@web51309.mail.yahoo.com>

I am using Toad and using the User B to view database object created by User A. THis select priviliges is been provided by granting SELECT on all SCHAME A database object so ROLE and assigning Role to USER B,

Now user B cannot see the Source COde of User A and I don't wnat ot give execute priviliges to User B.

Any workaround

TIA
Sanjay                 

---

Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com  

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 01 2004 - 12:52:02 CST