oracle show users code example

Example: oracle list users

SELECT * FROM DBA_USERS WHERE USERNAME = 'MY_USER';