Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between "select_catalog_role" and "select any dictionary"

Re: Difference between "select_catalog_role" and "select any dictionary"

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Wed, 14 Jan 2004 05:06:36 GMT
Message-Id: <pan.2004.01.14.05.08.08.274296@adelphia.net>


On Tue, 13 Jan 2004 19:10:24 -0800, Kelvin wrote:

> Dear ALL,
>
> Does anyone tell me when to use "select_catalog_role" and when to use
> "select any dictionary". I know that the "select_catalog_role" should
> logout and login again to take effect and "select any dictionary"
> does not. Any more major usage difference ?

Select any dictionary is a system privilege and select_catalog_role is a role. That's it. You can use both as you see fit.

-- 
None of us is as dumb as all of us.
(http://www.despair.com/meetings.html)
Received on Tue Jan 13 2004 - 23:06:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US