Drop and Create an User in Oracle

You can use below statements to drop an existing user and recreate it with appropriate privileges..




DROP USER MY_USER CASCADE
/


CREATE USER MY_USER
    IDENTIFIED BY MY_USER
    DEFAULT TABLESPACE MYTBS
    TEMPORARY TABLESPACE temp
/
GRANT DBA TO MY_USER
/
GRANT SELECT ANY TABLE TO MY_USER
/
GRANT INSERT ANY TABLE TO MY_USER
/
GRANT UPDATE ANY TABLE TO MY_USER
/
GRANT DELETE ANY TABLE TO MY_USER
/
GRANT ALTER ANY TABLE TO MY_USER
/
GRANT EXECUTE ANY PROCEDURE TO MY_USER
/
GRANT SELECT ANY SEQUENCE to MY_USER
/