Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLESPACE mi_tablespace datafile 'D:\TallerBaseDeDatos\DATAFILES\DATAFILE3.DBF' SIZE 300 m autoextend ON NEXT 500 k maxsize 800 m;
- SELECT *
- FROM dba_data_files;
- --CREACION DE ROLES
- CREATE ROLE creadorobjt;
- --DANDOLE PERMISO DE ADMINISTRADOR
- GRANT DBA TO CREADOROBJT;
- --CREACION DE USUARIOS
- CREATE USER EROBLES IDENTIFIED BY EMILIANO
- DEFAULT TABLESPACE mi_tablespace -- TODO LO QUE EL USUARIO HAGA SE GUARDA EN ESTE TABLESPACE
- TEMPORARY TABLESPACE TEMP;
- --
- GRANT UNLIMITED TABLESPACE TO EROBLES;
- GRANT CREADOROBJT TO EROBLES;
- /*
- GRANT CREATE SESSION TO CREADOROBJT; --SESION DE USUARIO
- GRANT CREATE ALTER SESSION TO CREADOROBJT;
- GRANT CREATE TABLE TO CREADOROBJT;
- GRANT SELECT ANY TABLE TO CREADOROBJT;
- GRANT CREATE ANY TABLE TO CREADOROBJT;
- GRANT ALTER ANY TABLE TO CREADOROBJT;
- GRANT CREATE ROLE TO CREADOROBJT;
- GRANT CREATE USER TO CREADOROBJT;
- GRANT CREATE VIEW TO CREADOROBJT;
- GRANT CREATE ANY INDEX TO CREADOROBJT;
- GRANT ALTER INDEX TO CREADOROBJT;
- GRANT CREATE PROCEDURE TO CREADOROBJT;
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement