Statement for creating user in Oracle SQL Database:
SQL> create user username identified by password;
e.g : SQL> create user prasad identified by pras123;
Statement for giving permissions to Oracle SQL Database:
SQL> grant connect ,resource to username;
e.g : SQL> grant connect ,resource to prasad;
Statement for unlocking user account in Oracle SQL Database:
SQL>alter user username account UNLOCK;
e.g : SQL>alter user prasad account UNLOCK;
