Health Checkup

Hi,

 

I want to do the health checkup of my database (eg:tablespace)

 

From where should I start the analysing?

 

Regards

Mamta

 

________________________________

From: NEELI-SC, Mamta 
Sent: Friday, 28 November 2008 12:40
To: 'ora-apps-dba@xxxxxxxxxxxxx'
Subject: RE: Schema access

 

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: