Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- HABILITA RESOURCE LIMIT
- ALTER SYSTEM SET RESOURCE_LIMIT = TRUE SCOPE=BOTH;
- -- CREA PERFIL
- CREATE PROFILE DBA_PRUEBA2 LIMIT
- IDLE_TIME 120
- SESSIONS_PER_USER 1
- CONNECT_TIME 60;
- -- CREA ROL Y DA GRANTS
- CREATE ROLE ROL_DBA;
- GRANT CONNECT TO ROL_DBA;
- GRANT CREATE TABLE TO ROL_DBA;
- GRANT CREATE USER TO ROL_DBA;
- --GRANT CREATE SESSION GRANT ANY PRIVILEGE TO ROL_DBA;
- -- CREA USUARIO
- CREATE USER INACAP_PRUEBA2 IDENTIFIED BY "PRUEBA2" DEFAULT TABLESPACE USERS QUOTA 1M ON USERS;
- GRANT ROL_DBA TO INACAP_PRUEBA2;
- --
- --
- CREATE TABLE INACAP_PRUEBA2.TIPO_AUTO
- (
- CODIGO NUMBER(4) PRIMARY KEY,
- NOMBRE VARCHAR2(100) NOT NULL
- );
- CREATE TABLE INACAP_PRUEBA2.AUTO
- (
- CODIGO NUMBER(4) PRIMARY KEY,
- PATENTE VARCHAR2(6) NOT NULL,
- DUENO VARCHAR2(100) NOT NULL,
- TIPO_AUTO_CODIGO NUMBER(4) NOT NULL,
- CONSTRAINT FK_TIPO_AUTO_CODIGO FOREIGN KEY (TIPO_AUTO_CODIGO) REFERENCES TIPO_AUTO(CODIGO)
- );
- CREATE ROLE COTIZADOR;
- GRANT CONNECT TO COTIZADOR;
- GRANT SELECT ON INACAP_PRUEBA2.TIPO_AUTO TO COTIZADOR;
- GRANT SELECT ON INACAP_PRUEBA2.AUTO TO COTIZADOR;
- GRANT INSERT ON INACAP_PRUEBA2.AUTO TO COTIZADOR;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement