define schema='schema_name'create user &schema identified by password; /* no "create session" privilege for schema */alter user &schema quota unlimited on tspname1​ quota unlimited on tspname2;

Next: Page 2
Back Up: Oracle