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;