a newbie question

[maswien]

I know there are 3 kinds of dictionary views that a user can access,

dba_xxx , all the objects the dba can access
all_xxx , all the objects the current user can access
user_xxx , all the objects in user's schema

how to understand following?

dba_users, all_users, user_users

thanks

 

[SantaMufasa]

Masvien,

DBA_USERS: The following columns for all created users in the database:
USERNAME
USER_ID
PASSWORD
ACCOUNT_STATUS
LOCK_DATE
EXPIRY_DATE
DEFAULT_TABLESPACE
TEMPORARY_TABLESPACE
CREATED
PROFILE
INITIAL_RSRC_CONSUMER_GROUP
EXTERNAL_NAME

ALL_USERS: The following columns for all created users in the database:
USERNAME
USER_ID
CREATED

USER_USERS: The following columns for just the one, currently connected, querying user:

USERNAME
USER_ID
ACCOUNT_STATUS
LOCK_DATE
EXPIRY_DATE
DEFAULT_TABLESPACE
TEMPORARY_TABLESPACE
CREATED
INITIAL_RSRC_CONSUMER_GROUP
EXTERNAL_NAME

Let us know if this answers your questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[maswien]

Thanks Mufasa,

so no matter which user login oracle, as long as he as the select permission to the table, following SQL will return the same results:

select * from dba_users
select * from all_users

Am I right?

 

[SantaMufasa]

DBA_USERS and ALL_USERS return the same number of rows, but DBA_USERS returns 9 more columns.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Turkbear]

Hi,
In addition, not all users will be able to query
DBA_USERS





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

...as long as he as the select permission to the table...

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.