Re: What's different for ALL_ , DBA

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 20 Jun 2002 13:53:08 +1000
Message-ID: <aerjk6$h1e$1@lust.ihug.co.nz>

"enochhsieh" <enochshiesh_at_ebtelco.com> wrote in message news:6ad12aee.0206191923.2dbc9973_at_posting.google.com...
> Hi Everybody :
>
> Who can tell me what 's different for the data directory talbe
> begin with ALL_ and DBA_ ?
>
> Thank you very much

USER_ views are accessible by any User, and displays all the relevant objects for which the User is the owner.

ALL_ views are accessible by any User, and display all the relevant objects to which the User has been granted access, whether or not he actually owns them.

DBA_ views are accessible only by DBAs (usually), and display all relevant objects, throughout the database, whether or not you are the owner, and whether or not you actually have access to them via select, update, delete, execute etc privileges.

Regards
HJR Received on Wed Jun 19 2002 - 22:53:08 CDT

Re: What's different for ALL_ , DBA_ ?