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: What's different for ALL_ , DBA_ ?

Re: What's different for ALL_ , DBA_ ?

From: Christopher Merry <merryct_at_constructingbits.com>
Date: Wed, 19 Jun 2002 20:58:21 -0700
Message-ID: <uh2kn7crnp4s06@corp.supernews.com>


Views prefixed with all_ contain objects the current user has privilege to access; the dba_ prefix indicates all objects in the database.

The significance between the two really comes down to privilege. Most users will not have access to the dba_ views.

"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
Received on Wed Jun 19 2002 - 22:58:21 CDT

Original text of this message

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