User and Privilege Manage

Create a User

You must use manager(Such as "sys" or "system") to login who has the power to create and manage database users.

COMMAND:

create user username IDENTIFIED BY password;

As new user is just created and now any privileges, it will say the new user cann't create SESSION when you  try to login by the new user through sqlplus .

So we need to give the new user privileges.

Grant Privilege

1.GRANT CREATE SESSION TO newuser;

2.GRANT CREATE TABLE TO newuser;

3.GRANT CONNECT,RESOURCE TO newuser;

4.GRANT SELECT ON scotter.emp TO newuser;

User Manage

1.ALTER USER newuser IDENTIFIED BY newpwd;

2.ALTER USER newuser PASSWORD EXPIRE; This will force the newuser to give a new password when he first logs in.

3.ALTER USER newuser ACCOUNT LOCK;

4.ALTER USER newuser ACCOUNT UNLOCK;

REVOKE Privileges

1.REVOKE SELECT ON scotter.emp form newuser;

2.REVOKE CONNECT,RESOURCE,CREATE TABLE,CREATE SESSION from newuser;

3.DROP USER newuser CASCADE;