Social Icons

jueves, 1 de febrero de 2024

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;

Descargar cliente de Oracle 19c

  Oracle Database 19c Download for Microsoft Windows x64 (64-bit) https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

 
 
Blogger Templates