PRIVILEGIOS SDE CREATE GEODATBASE

CREATE USER SDE IDENTIEFIED BY sde112 

PRIVILEGIOS SDE

CREATE USER SDE IDENTIfied BY sde112 

GRANT EXECUTE ON dbms_pipe TO public;

GRANT EXECUTE ON dbms_lock TO public;

GRANT EXECUTE ON dbms_lob TO public;

GRANT EXECUTE ON dbms_utility TO public;

GRANT EXECUTE ON dbms_sql TO public;

GRANT EXECUTE ON utl_raw TO public;

GRANT ADMINISTER DATABASE TRIGGER TO SDE;

GRANT ALTER ANY INDEX TO SDE;

GRANT ALTER SYSTEM TO SDE;

GRANT CREATE ANY INDEX TO SDE;

GRANT CREATE ANY TRIGGER TO SDE;

GRANT CREATE ANY VIEW TO SDE;

GRANT CREATE INDEXTYPE TO SDE;

GRANT CREATE LIBRARY TO SDE;

GRANT CREATE OPERATOR TO SDE;

GRANT CREATE PROCEDURE TO SDE;

GRANT CREATE PUBLIC SYNONYM TO SDE;

GRANT CREATE SEQUENCE TO SDE;

GRANT CREATE SESSION TO SDE;

GRANT CREATE TABLE TO SDE;

GRANT CREATE TRIGGER TO SDE;

GRANT CREATE TYPE TO SDE;

GRANT CREATE VIEW TO SDE;

GRANT DROP ANY INDEX TO SDE;

GRANT DROP ANY VIEW TO SDE;

GRANT DROP PUBLIC SYNONYM TO SDE;

GRANT INHERIT ANY PRIVILEGES TO SDE;

GRANT SELECT ANY TABLE TO SDE;

GRANT EXECUTE ON DBMS_CRYPTO  TO SDE;

GRANT ADMINISTER DATABASE TRIGGER

GRANT SELECT_CATALOG_ROLE TO SDE; 

ROLES

SELECT_CATALOG_ROLE

true

false

true

PRIVILEGIOS DE PAQUETE

GRANT EXECUTE ON dbms_pipe TO public; GRANT EXECUTE ON dbms_lock TO public; GRANT EXECUTE ON dbms_lob TO public; GRANT EXECUTE ON dbms_utility TO public; GRANT EXECUTE ON dbms_sql TO public; GRANT EXECUTE ON utl_raw TO public;