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;