› Fóruns › Banco de dados Oracle › Permissão plano de execução › Permissão plano de execução
Atualmente uso as seguintes permissões:
GRANT ALTER DATABASE TO USUARIO;
GRANT DEBUG ANY PROCEDURE TO USUARIO;
GRANT CREATE ANY INDEX TO USUARIO;
GRANT ALTER ANY INDEX TO USUARIO;
GRANT DROP ANY INDEX TO USUARIO;
GRANT CREATE ANY JOB TO USUARIO;
GRANT CREATE MATERIALIZED VIEW TO USUARIO;
GRANT DROP ANY MATERIALIZED VIEW TO USUARIO;
GRANT CREATE PROCEDURE TO USUARIO;
GRANT ALTER ANY PROCEDURE TO USUARIO;
GRANT DROP ANY PROCEDURE TO USUARIO;
GRANT EXECUTE ANY PROCEDURE TO USUARIO;
GRANT CREATE SEQUENCE TO USUARIO;
GRANT ALTER ANY SEQUENCE TO USUARIO;
GRANT DROP ANY SEQUENCE TO USUARIO;
GRANT SELECT ANY SEQUENCE TO USUARIO;
GRANT CREATE SYNONYM TO USUARIO;
GRANT CREATE TABLE TO USUARIO;
GRANT ALTER ANY TABLE TO USUARIO;
GRANT DELETE ANY TABLE TO USUARIO;
GRANT DROP ANY TABLE TO USUARIO;
GRANT INSERT ANY TABLE TO USUARIO;
GRANT SELECT ANY TABLE TO USUARIO;
GRANT UPDATE ANY TABLE TO USUARIO;
GRANT CREATE TRIGGER TO USUARIO;
GRANT ALTER ANY TRIGGER TO USUARIO;
GRANT DROP ANY TRIGGER TO USUARIO;
GRANT CREATE TYPE TO USUARIO;
GRANT ALTER ANY TYPE TO USUARIO;
GRANT DROP ANY TYPE TO USUARIO;
GRANT EXECUTE ANY TYPE TO USUARIO;
GRANT CREATE VIEW TO USUARIO;
GRANT DROP ANY VIEW TO USUARIO;
GRANT CREATE SESSION TO USUARIO;
GRANT UNLIMITED TABLESPACE TO USUARIO;
GRANT SELECT ON V_$SESSION TO USUARIO;