create user BILL identified by BILL
default tablespace BILL_DATA
temporary tablespace COMMON_TEMP
QUOTA UNLIMITED ON BILL_DATA
QUOTA UNLIMITED ON BILL_INDX
/
grant CREATE PROCEDURE to BILL
/
grant CREATE SEQUENCE to BILL
/
grant CREATE SNAPSHOT to BILL
/
grant CREATE TABLE to BILL
/
grant CREATE TRIGGER to BILL
/
grant CREATE VIEW to BILL
/
grant CREATE SESSION to BILL
/
alter user BILL DEFAULT ROLE ALL
/
---------------
On ne vit qu'une fois, mais pour qui sait vivre, une seule fois suffit (Merril Stubbing)