RE: Granting Select Any Table

I suggest that you create a role (for example select_mike_tables). This role can then be granted to anyone who needs access to mike's tables without having to explicitly grant access to each table.

Log on as mike and follow the suggestions below to to a mass grant of access to the select_mike_tables role.

> -----Original Message-----
> From: Larry Taylor [SMTP:ltaylor_at_iq.com]
> Sent: Thursday, December 14, 2000 2:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Granting Select Any Table
>
> What I mean is, grant Scott select privileges on all tables owned by Mike.
>
> Thanks for your response
>
> Larry
>
> -----Original Message-----
> Sent: Thursday, December 14, 2000 11:31 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Larry,
>
> For "mass" grants try generating a "slave" SQL script:
>
> set head off
> set linesize 250
> spool grant
> select 'Grant Select on '||table_name||' to user;' from user_tables;
> !mv grant.lst grant.sql
> @grant
>
>
> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com
>
>
> -----Original Message-----
> Sent: Thursday, December 14, 2000 11:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi folks,
>
> Does anyone know the best way to grant a user select any table of another
> users tables?
>
> Thanks in advance
>
> Larry
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
> INET: ltaylor_at_iq.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Barbour
> INET: dbarbour_at_connectsouth.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
> INET: ltaylor_at_iq.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Dec 14 2000 - 15:26:26 CST