Menu
How to find out the users list, which is all created in the oracle 11g database. Is there any command to find out the users list which we can execute from the Command line interface!
626
Show Current Logged User We can see the currently logged user in the database server by using the following query in the MySQL server: mysql> SELECT user, host, db, command FROM information_schema.
SQL> select * from dba_role_privs where granted_role='DBA'; The v$pwfile_users view contains a list of all users who have been granted the SYSDBA or SYSOPER privilege.
In Oracle terminology, a user is someone who can connect to a database (if granted enough privileges) and optionally (again, if granted the appropriate privileges) can own objects (such as tables) in the database. The objects a user owns are collectively called >schema.
I am not sure what you understand by "execute from the Command line interface", but you're probably looking after the following select statement:
select * from dba_users; or
select username from dba_users; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
