Data Dictionary Views

[pointers]

Hi,

Could you pls explain me the confusing, diffterece between the views "USER_ " , "ALL_" and "DBA_".

On which table query should be executed to get all the list of views like user_constraint s, user_sons_const raints, user_source,use r_sequences etc.


Regards
Pointers.

[debasisdas]

the USER_.......... .views contains info about user data but SYS_........... . and ALL_...... contains data of all other users also to which notrmal users may not have priviliges.

[BMantri]

Hello,

USER_ : contain information about objects owned by the account
performing the SQL query (current user)
ALL_ : Rows in the ALL views include rows of the USER views and all information about
objects that are accessible to the current user.

DBA_ : The DBA views encompass information about all database objects, regardless of the
owner. Only users with DBA privileges can access these views.

For more info, please refer http://www.db.cs.ucdav is.edu/teaching/sqltutorial/chap3-1.pdf

Hope this will help you :)

Regards,
BMantri