From JTESTA@longaberger.com Thu, 02 Aug 2001 22:49:54 -0700
From: "JOE TESTA" <JTESTA@longaberger.com>
Date: Thu, 02 Aug 2001 22:49:54 -0700
Subject: Re: grants to schema query
Message-ID: <F001.0035DA10.20010802082618@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



as owner:
 
spool /tmp/update_all.spl
select 'grant update on '||table_name||' to user;' from 
user_tables;
spool off
@/tmp/update_all.spl
 
joe
>>> Sean.ONeill@organon.ie 08/02/01 11:01AM 
>>>Hope there is not an obvious answer to this..... I want to grant 
UPDATE privto all objects in a schema to a user.  Do I need to grant to 
each object orcan I somehow wildcard all the objects?.  What are my 
option(s)?.  I'dappreciate example grant statements!Sean 
:)Rookie Data Base AdministratorOracle 7.3.3, 8.0.5, 8.1.7 - NT, 
W2K[0%] OCP Oracle8i DBA[0%] OCP Oracle9i 
DBA-------------------------------- ------------ Organon (Ireland) 
Ltd.E-mail: sean.oneill@organon.ie   [subscribed: Digest 
Mode]Visit: <A 
href="http://groups.yahoo.com/group/Oracle-OCP-DBA">http://groups.yahoo.com/group/Oracle-OCP-DBA"Nobody 
loves me but my mother... and she could be jivin' too."  - BB 
King-- Please see the official ORACLE-L FAQ: <A 
href="http://www.orafaq.com">http://www.orafaq.com-- Author: 
O'Neill, Sean  INET: Sean.ONeill@organon.ieFat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California        -- Public Internet 
access / Mailing 
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).