The following section goes through an example schema creation configuration:
create user multimedia identified by mypassword; grant create session, create table, create procedure to multimedia; grant create view, create role, create trigger to multimedia;
The following statements enable the schema to access the temporary tablespaces (in this case it's assumed to be called TEMP) and be able to have storage rights in the tablespace called USERS:
alter user multimedia temporary tablespace temp; alter user multimedia quota unlimited on users; alter user multimedia default tablespace users;
The following two permissions are optional but can prove to be useful. They allow the schema to access the
dbms_lock.sleep command (useful for asynchronous ...