Useful SQL Statement DBA Beginners

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;