Hi akki,
You can use the command:
Grant select an any table to <username>;

The user should query the table as <user holding the table>.tablename.
Hope this helps.
Regards,
Hari



"akki "
<oracledba-ezmlms
hield-x89034888.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
10/06/2004 08:07
AM Subject
HOW TO GRANT SELECT ON ALL TABLES










hi list ...
plz tell me

HOW TO GRANT SELECT ON ALL TABLES OF A PARTICULAR USER TO ANOTHER USER..?
thanks
akki



--------
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