Oracle PL/SQL/User Previliege/Drop User

Create a user and then drop it

create user sqle identified by password;
grant create session, dba to sqle;
connect sqle/password;
--DROP USER sqle;

Create user, grant permission and drop user

 
SQL>
SQL>
SQL> create user dropme
  2      identified by doomed
  3      default tablespace users
  4      temporary tablespace temp
  5      quota unlimited on users
  6      /
User created.
SQL>
SQL> grant create session, create table
  2      to dropme
  3      /
Grant succeeded.
SQL>
SQL> drop user dropme;
User dropped.
SQL>
SQL>

If Tom owns a table. Use the CASCADE keyword to drop it

 

drop user Tom cascade;