RE: select on v$ tables

From: Anand <karhadkar_at_rolta.com>
Date: Mon, 23 Jul 2001 02:29:01 -0700
Message-ID: <F001.00351351.20010723022554@fatcity.com>

Hi,
Just grant privilege 'select any table' to scott user OR grant DBA role to scott.\

Regards,
Anand.

-----Original Message-----
maganti
Sent: Monday, July 23, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L

hi dba's

i need to give select permission to scott user on all v$ tables.

is there any role for that. or should i grant the selection using dynamic sql

thanx in advance
prasad

---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: prasad maganti
  INET: prasadm_g_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anand
  INET: karhadkar_at_rolta.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Jul 23 2001 - 04:29:01 CDT