Re: access to v$ views, DBA

From: Marek Wiechula and Sheila Plant <sparemgw_at_batelco.com.bh>
Date: 1996/11/09
Message-ID: <328517C5.1BEA@batelco.com.bh>#1/1

Michael Serbanescu wrote:
>
> for the DBA_ tables, but I believe that now those tables have public
> synonyms; thus, by simply granting them SELECT ANY TABLE privilege, they
> will be able to look at the DBA_ tables.
>

I would advise against granting SELECT ANY TABLE privilege except in extremely rare circumstances. I think it is much too large a hammer for a nut as small as the DBA tables and dynamic performance tables.

Marek Received on Sat Nov 09 1996 - 00:00:00 CST

Re: access to v$ views, DBA_ tables etc