RE: Schema access

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: