Hi Jason

Create new user, let say B, with only "create session" and "alter session"
privileges. Then from other user, lets say A, create new role with specific
name, lets say R. Give select privileges on tables to R and grant R to B.

Hope this will be clear.

Regards,

Mohit Singla, Valu America Inc.,113 Technology Drive,Pittsburgh, PA, 15275
Tel: - 412-494-0400 Ext. 8107


-----Original Message-----
From: Jason Spencer
[mailto:oracledba-ezmlmshield-x59997868.[Email address protected]
Sent: Wednesday, August 04, 2004 10:12 AM
To: LazyDBA Discussion
Subject: Help with read only access

Hello All,
A developer wants to use SQPLUS with read only privileges
Can any one tell me how to grant read only privileges to sqlplus so he
can access our oracle database?

Thanks
jason



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page