Re: Newbie question .....

"Mark Wagoner" <mwagoner_at_iac.net> wrote in message news:<adi70g$2o3o$1_at_genma.iac.net>...
> I could write a book to answer the questions you ask (in fact, people have)
> but here are a few pointers to get you started.
>
> There are two sets of views that you can query for the metainformation. The
> ALL_??? views contain information about all database objects but you must be
> logged in as a dba to view them.

This is incorrect in two respects. There are THREE sets of views to query information on, not two: ALL_??? views, DBA_??? views and USER_??? views.

ALL_??? views: pertaining to all of the objects the current user has ACCESS to (this does NOT need DBA privileges to view).

USER_??? views: pertaining to all of the objects the current user OWNS. DBA_??? views: pertaining to ALL objects in the database. This set DOES require DBA access to view.

The ALL_??? views may or may not contain information about all objects in the database, depending upon the access level of the connected user. For an account with DBA privileges the ALL_??? views will contain the same objects as the DBA_??? views, since the DBA role has acess to every object in the database. For all other accounts the ALL_??? views will contain information only on the objects the user has some sort of access to, either by role or by specific grant to that user.

> ... The USER_??? views hold data about objects
> owned or accessible to the current user. In many cases there is both a ALL_
> and USER_ view such as:
>
> ALL_TABLES displays all tables, USER_TABLES displays tables owned by the
> current user.
> ALL_INDEXES displays all indexes, USER_INDEXES displays indexes owned by the
> current user.
> There is also ALL_/USER_CONSTRAINTS showing constraint information and
> ALL_/USER_USERS showing defined users, although USER_USERS is not much use
> if you ask me.
>
> The above views a based on the system V$??? views. You should read the
> documentation for details on these, but the V$SESSION view will show you who
> is current logged in, where there are logged in from, when they logged in,
> etc.
>
> HTH
>
>
>
> "Mahesh Hardikar" <hardikarm_at_yahoo.com> wrote in message
> news:4a1c57c2.0206040130.1d896974_at_posting.google.com...
> > Hello ,
> >
> > I am a Newbie in Oracle . How do I find out table related information
> > like :
> >
> > Current Size of Table & its related Index
> > Dependencies of / upon Table
> > Index columns of table
> > Permissions on the table
> >
> > Also I want to find out currently connected users to Oracle Instance &
> > the last command run by those users.
> >
> > I know I can use Enterprise Manager but I want to know commands from
> > SQL Plus.
> >
> > I have created a user with default tablespace as USERS . User has
> > CONNECT & DBA Previlages. I then created a table using newly created
> > user. I checked with desc tab_name but it gives me information only
> > about column names & datatypes.
> >
> > I tried doing selects on some views of SYSTEM user . But those doesnot
> > seem to have any information about objects on different Tablespace.
> > Correct me if I am wrong.
> >
> > Thanks
> > Mahesh
Received on Tue Jun 04 2002 - 13:40:28 CDT