create tablespace LIGHTBOX_SPACE
datafile 'C:\ORACLEXE\ORADATA\XE\LIGHTBOX.DBF'
	size 5M
	autoextend on
	next 1M
	maxsize unlimited
segment space management AUTO

CREATE USER LIGHTBOX
	IDENTIFIED BY LIGHTBOX
	DEFAULT TABLESPACE LIGHTBOX_SPACE
	TEMPORARY TABLESPACE TEMP
	QUOTA UNLIMITED ON LIGHTBOX_SPACE
	ACCOUNT UNLOCK;
GRANT 
	 ALTER PROFILE 
	,ALTER SESSION 
	,ALTER SYSTEM 
	,ALTER TABLESPACE 
	,ALTER USER 
	,CREATE PROCEDURE 
	,CREATE PROFILE 
	,CREATE PUBLIC SYNONYM 
	,CREATE ROLE 
	,CREATE ROLLBACK SEGMENT 
	,CREATE SEQUENCE 
	,CREATE SESSION 
	,CREATE SYNONYM 
	,CREATE TABLE 
	,CREATE TABLESPACE 
	,CREATE TRIGGER 
	,CREATE VIEW 
	,EXECUTE ANY PROCEDURE 
	,SELECT ANY DICTIONARY 
	,SELECT ANY SEQUENCE 
	,SELECT ANY TABLE
TO LIGHTBOX;