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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 14 Jan 2004 09:52:10 +0100
Message-ID: <400502d0$0$7156$626a54ce@news.free.fr>

"Kelvin" <kamingbb_at_yahoo.com> a écrit dans le message de news:592e04fe.0401131910.2a7d21c8_at_posting.google.com...
> 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 ?
>
> Thanks in advance.
>
> Kind Regards,
> Kelvin

select_catalog_role allows you to select on the catalog views (dba%, v$%...). select any dictionary allows you to select the dictionary tables that is sys tables. You can't select sys tables with only select_catalog_role role.

Regards
Michel Cadot Received on Wed Jan 14 2004 - 02:52:10 CST