But the Oracle manuals have been advising users for
years that the CONNECT, RESOURCE, and DBA
roles exist only for backwards compatibility and
should not be used in future developments. Each site
is supposed to design its own roles, so it is perfectly
reasonable for the ALL_ and USER_ views to be
unavailable at a well-controlled site.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Daniel A. Morgan wrote in message <3B292BAC.3BA6BC2A_at_attws.com>...
>It is impossible to not have access to user_ and all_ views unless the only
>privilege you have is create session. SELECT from these is standard in the
GRANT
>CONNECT role.
Received on Sat Jul 21 2001 - 16:52:44 CDT
