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