[askdba] Re: [dba_gurus] hw to grant on DBA_ and v$ views?
- From: sunil bhola <oraclebhola@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx, Chirag DBA <chiragdba@xxxxxxxxx>, dba gurus <dba_gurus@xxxxxxxxxxxxxxx>
- Date: Thu, 27 Jan 2005 05:00:47 -0800 (PST)
Hi i am agree with everyone, but the drawback for this is if you grant
Select_catalog_role to user then user can access any table. So where is
security at all. I think there is another way if you create a new view on that
view and than grant the privilege on that view, that will be quite better.
:-)
Nisar Tareen <ntareen@xxxxxxxxx> wrote:
Chirag,
Grant Select_catlog_role to that user.
Nisar Tareen
Chirag DBA wrote:
Hi Friends..!!
How to grant select to a user on DBA_ and V$ views?
Grant Select any table to USER1; will do that?
or I need to give select any catalogue role?
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
Other related posts:
