ClubEnsayos.com - Ensayos de Calidad, Tareas y Monografias
Buscar

Creacion de usuarios en oracle sobre solaris


Enviado por   •  28 de Octubre de 2015  •  Apuntes  •  289 Palabras (2 Páginas)  •  89 Visitas

Página 1 de 2

/********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

...

Descargar como (para miembros actualizados) txt (3 Kb) pdf (42 Kb) docx (12 Kb)
Leer 1 página más »
Disponible sólo en Clubensayos.com