RE: Schema access
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Thu, 27 Nov 2008 20:47:27 -0700
You could try something like this in sql*plus to create a script with
the commands in it and then just execute that script. You would need to
be connect as a user with DBA privs. You could also run it while logged
in as user_A by changing dba_objects to user_objects. In that case, the
owner stuff is not needed but it doesn't hurt to have it in.
hth,
-joe
set pagesize 0
set linesize 132
set trimspool on
set feedback off
set heading off
spool grant-select.sql
select 'grant select on ' || owner || '.' || object_name || ' to
<user_B>;'
from dba_objects
where object_type in ('TABLE', 'VIEW')
and owner = '<user_A>'
order by owner, object_name
/
________________________________
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of NEELI-SC, Mamta
Sent: Thursday, November 27, 2008 7:45 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: reg:Schema access
Hi,
I have a user (user A) in oracle who has a lot of objects under their
schema, I wish to give select access on these tables to another user
(user B).
Can any help me on this please.
Regards
Mamta
Other related posts:
