Re: Schema specific grants

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 12 Feb 2003 10:09:16 -0800
Message-ID: <F001.0054AE5A.20030212100916@fatcity.com>

select 'grant insert on '||table_name||' to guest;' from user_tables

spool \tmp\grant_insert.sql
/
@\tmp\grant_insert.sql

there is no "one shot" command that I know of

• Bob Metelsky <bmetelsky_at_CPS92.COM> wrote:
  > Good Morning All
  >
  > Im looking at trying to grant privilidges to a "guest" user (who does
  > not own the tables)
  >
  > I know I can do it for individual tables
  >
  > Eg
  > GRANT INSERT ANY SCHEMA_NAME.TABLE_NAME TO Guest;
  >
  >
  > but I need to grant to an entrie schema
  > Like
  > GRANT INSERT ANY SCHEMA_NAME.* TO Guest;
  >
  >
  > Anyone have the syntax for that?
  >
  > Many thanks
  > bob
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: Bob Metelsky
  > INET: bmetelsky_at_cps92.com
  >
  > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  > San Diego, California -- Mailing list and web hosting services
  > ---------------------------------------------------------------------
  > 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).
  >
  

  ---

Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Wed Feb 12 2003 - 12:09:16 CST