Creating user & Dropping user using SQL Command

STEPS:-
1. open command prompt
2. login into sqlplus with user: sqlplus sys/password as sysdba
3. create a user using sql command
SYNTAX: CREATE USER username IDENTIFIED BY paswword DEFAULT TABLESPACE tablespacename TEMPORARY TABLESPACE tablespacename QUOTA 5M ON USER ACCOUNT lock/unlock;
or
CREATE USER username IDENTIFIED BY paswword
4. give system privileges GRANT CREATE SESSION, CREATE TABLE TO username;
5. login to user using SQL developer and sqlplus now login into sys user in sql developer
6. droping user which is connected to database follow the step
- login into sys user with admin mode
- ALTER SYSTEM ENABLE RESTRICTED SESSION
- SELECT sid,serial# FROM V$SESSION WHERE username='clerk';
(OR) SELECT * FROM V$SESSION;
- ALTER SYSTEM KILL SESSION 'sidno','serial#no';
- DROP USER username CASCADE;

• Tweet
• Share
• Share
• Share
• Share

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Related Post