sábado, 3 de abril de 2010

RM/Oracle - Usuarios

Script de criação de usuários - Oracle

CREATE USER RM
IDENTIFIED BY RM
DEFAULT TABLESPACE RM_DADOS
TEMPORARY TABLESPACE RM_TMP;

CREATE USER SYSDBA
IDENTIFIED BY masterkey
DEFAULT TABLESPACE RM_DADOS
TEMPORARY TABLESPACE RM_TMP;


CREATE ROLE ACESSO_RM;

GRANT CONNECT,DBA,RESOURCE TO RM;

GRANT CONNECT, RESOURCE TO ACESSO_RM;

GRANT CONNECT,RESOURCE,ACESSO_RM TO SYSDBA;

ALTER USER SYSDBA
DEFAULT ROLE ALL;