RE: Schema access
- From: "NEELI-SC, Mamta" <Mamta.NEELI@xxxxxxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Fri, 28 Nov 2008 12:40:00 +0800
Hi Joe,
It meets my requirement thanks a ton!!
Regards
Mamta
________________________________
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Sweetser, Joe
Sent: Friday, 28 November 2008 11:47
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: 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
/
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient,
you should not use, copy, disclose, distribute or take any action based
on this message. If you have received this message in error, please
advise the sender immediately by reply email and delete this message.
Although ICAT Holdings, LLC, Underwriters at Lloyd's, Syndicate 4242,
scans e-mail and attachments for viruses, it does not guarantee that
either are virus-free and accepts no liability for any damage sustained
as a result of viruses. Thank you.
Disclaimer added by CodeTwo Exchange Rules
www.codetwo.com
________________________________
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:
