CREAR USUARIO
Syntax:
CREATE USER username
IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'external_name'}
options;
options:
DEFAULT TABLESPACE tablespace
TEMPORARY TABLESPACE tablespace
QUOTA int {K | M} ON tablespace
QUOTA UNLIMITED ON tablespace
PROFILE profile_name
PASSWORD EXPIRE
ACCOUNT {LOCK|UNLOCK}
Ejemplo básico:
CREATE USER USU_EXA IDENTIFIED BY USUEXA;
http://ss64.com/ora/user_c.html
DAR PERMISOS AL NUEVO USUARIO
GRANT ALL PRIVILEGES TO USU_EXA
o
GRANT CREATE SESSION,
CREATE TABLE,
CREATE VIEW,
CREATE TRIGGER,
CREATE SEQUENCE
TO USU_EXA;
Mas información http://ora.u440.com/usuarios/grant.html
CREAR TABLESPACE
Syntax:
CREATE [UNDO] TABLESPACE tablespace_name
DATAFILE Datafile_Options Storage_Options ;
Datafile_Options:
'filespec' [AUTOEXTEND OFF]
'filespec' [AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]]
Ejemplo básco:
CREATE TABLESPACE EXA_TBS_TBL
DATAFILE 'C:\oraclexe\oradata\xe\EXA_TBS_TBL.DBF' SIZE 10 M;
CREATE TABLESPACE EXA_TBS_IND
DATAFILE 'C:/oraclexe\oradata\xe\EXA_TBS_IND' SIZE 10M;
http://ss64.com/ora/tablespace_c.html