Pular para o conteúdo

Fóruns Banco de dados Oracle Permissão plano de execução Permissão plano de execução

#101410
DBA_LUCAS
Participante

    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;