Privileges have to be granted one object at a time.
My preferred method is to grant the privileges to a role and then grant the role to
the user. Then if you need to do the same to another user, you just grant them the
role also.
> -Original Message-
> From: O'Neill, Sean [mailto:[EM
You have to do them individually, but you can use SQL to write the script,
as follows (use SQL*Plus to log in to Oracle as the schema owner):
set pages 0 feedb off trimspool on lines 200 wrap off
select 'grant update on '||table_name||' to ;' from user_tables
spool grantem.sql
/
spool off
@grant
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
>>> [EMAIL PROTECTED] 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
Try
1. creating a role for the updates.
2. running a query against the dba_tables table that will generate all the
grants neeeded to the role.
3. Spool that query to a file.
4. Run the resultant file as the schema that owns the tables you want access
granted on.
For example:
-- Log in as your f
grant to each object ... but you can sorta kinda wildcard it as follows:
select 'grant update on '||owner|'.'||object_name||' to ;'
from dba_objects where owner='' and
object_type in ('TABLE','VIEW','SEQUENCE',);
spool to a file, then run the file as either the object owner, or as someone
w
Write a script that dynamically builds your script to create the grants.
Dynamically building scripts is very important in making your life much
easier. The data dictionary is your friend.
-Original Message-
Sent: Thursday, August 02, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L
I think you need to something like
CREATE ROLE upd_privs;
GRANT UPDATE ON table1 TO upd_privs;
GRANT UPDATE ON tableN TO upd_privs;
GRANT upd_privs TO username;
Rick
-Original Message-
Sent: Thursday, August 02, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Hope there is not