Creacion de usuarios en oracle sobre solaris
pepalalaApuntes28 de Octubre de 2015
289 Palabras (2 Páginas)117 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
quota unlimited on datemec
quota unlimited on indices;
grant role_dba_datos to bdemec;
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 emoe identified by emoe
default tablespace datemoe
quota unlimited on datemoe
quota unlimited on indices;
grant role_dba_datos to emoe;
//////////////////******************************//////
select file_name,SUM(bytes)/1024/1024 from dba_data_files where tablespace_name='DATITER15_VAL'
group by file_name;
///////////////////*************************/////
alter database datafile '/inter15_4/inter15/DATAFILES/datiter15_val05.dbf'resize
...