Create user, grant permission and drop user : Drop User « User Previliege « Oracle PL / SQL






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>

 








Related examples in the same category

1.Create a user and then drop it
2.If Tom owns a table. Use the CASCADE keyword to drop it