Creacion de usuarios en oracle sobre solaris
Enviado por pepalala • 28 de Octubre de 2015 • Apuntes • 289 Palabras (2 Páginas) • 73 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
...