Creacion de usuarios en oracle sobre solaris
Enviado por pepalala • 28 de Octubre de 2015 • Apuntes • 289 Palabras (2 Páginas) • 88 Visitas
/********PASO 1. CREACION DE TABLESPACE*****************///
create tablespace datenafin_val_2015 datafile
'/bdpro1_7/bdpro1/DATAFILES/datenafin_val_2015_01.dbf' size 1024m
autoextend off extent management local uniform size 512k
segment space management auto;
/////********PASO 2. CREACION DE USUARIO*************/////////
create user dir_enc_men identified by dir_enc_men
default tablespace datdir_enc_men
quota unlimited on datdir_enc_men
quota unlimited on indices;
////*******PASO 3. DAR PRIVILEGIOS*************//////////////
grant role_dba_datos to dir_enc_men;
////////******PASO 4. DAR PROFILE*****************/////////////
alter user dir_enc_men profile profile_usuario;
create user admuni_opmen identified by admuni_opmen
default tablespace datadmuni
quota unlimited on datadmuni
quota unlimited on dateim
quota unlimited on indices;
grant role_dba_datos to admuni_opmen;
create user enec_op identified by enec_op
default tablespace datencop
quota unlimited on datencop;
quota unlimited on indices;
grant role_dba_datos to enec_op;
create user emec_op identified by emec_op
default tablespace datencop
quota unlimited on datencop;
quota unlimited on indices;
grant role_dba_datos to emec_op;
create user admuni_opmen identified by admuni_opmen
default tablespace datemec
quota unlimited on datemec
quota unlimited on indices;
grant role_dba_datos to admuni_opmen;
create user enec identified by enec
default tablespace datenec
quota unlimited on datenec
quota unlimited on indices;
grant role_dba_datos to enec;
create user immexn identified by immexn
default tablespace datimmexn
quota unlimited on datimmexn
quota unlimited on indices;
grant role_dba_datos to immexn;
create user enim identified by enim
default tablespace datenim
quota unlimited on datenim
quota unlimited on indices;
grant role_dba_datos to enim;
create user ems2005 identified by ems2005
default tablespace datems2005
quota unlimited on datems2005;
quota unlimited on indices;
grant role_dba_datos to ems2005;
create user bdemec identified by bdemec
default tablespace datemec
...