SQL>grant SELECT_ANY_TABLE to <user_name>;

Arshad
----- Original Message -----
From: "Hari Ganapathi "
<oracledba-ezmlmshield-x34648457.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, October 06, 2004 10:36 AM
Subject: Re: HOW TO GRANT SELECT ON ALL TABLES


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