Difference Between Select * from sys.dba_users and Select * from dba_users

Updated May 18, 2018

**Select * from sys.dba_users vs Select * from dba_users**

Hello Experts,

What is the difference between Select * from sys.dba_users and Select * from dba_users?

please provide me with the correct answer.

thanks in advance

Comments

07 Oct 2014 11:43 am Shalesh Singh Visen Helpful Answer

When you login to database as " sqlplus '/as sysdba', you logged in as sys user.. sys is user/schema, you can access your tables without specifying schema name that is 'sys.' , now suppose you have 2 users in database A & B , now you are connected to database as A user but you want to see objects of B user, for example, you have a table called T1 made by B user, so in order to see table T1 data you need to specify " select * from B.T1; " and if you are logged into database as B user/schema, then select * from T1; will show you data of T1 table....hope I am clear now.