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_at_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_at_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_at_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_at_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).
Received on Fri Aug 03 2001 - 00:49:54 CDT
