Revoke the privilige from the user

You can revoke the privilege from the user rimon by the following command:
REVOKE create session, create table,
create view, create sequence
FROM rimon;

SQL Command:
REVOKE create session, create table,
create view, create sequence
FROM user_name;

Delete user

If you have a user named rimon then you can delete the user by the following command:
DROP USER rimon;

SQL Command:
DROP USER user_name;

Change the password of the user

If you create a user named rimon then you can change that user's password by the following command.
ALTER USER rimon
IDENTIFIED BY 654321;

SQL Command:
ALTER USER user_name
IDENTIFIED BY password;

User System privilige

SQL - Command:
GRANT create session, create table,
create sequence, create view
TO user_name;


GRANT create session, create table,
create sequence, create view
TO rimon;

Create User

 SQL - Command:
CREATE USER user_name
IDENTIFIED BY password

If the user_name is rimon and the password is 123456 then the command will be
CREATE USER rimon
IDENTIFIED BY 123456