Oracle NOTE 1

--Create a new user name Shsfdb
Create user username
identified by password;
Default Tablespace tablespacename

--Give the user name role
Grant DBA to Shsfdb

--Query users
SELECT * FROM Dba_users

--Delete User
Drop User Shsfdb Cascade

--Change the password of the forgotten password user
Alter user username identified by NewPassword;

--Log in with DBA authority in the Command window format
Sqlplus/as SYSDBA

Show user; --Display the currently logged in user under the command window

Oracle NOTE 1