Verificando permissões e GRANTS de usuários

Verificando permissões do usuário TESTE_ORCL

SYS@ORCL > SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE 'TESTE_ORCL';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
TESTE_ORCL                      ALTER SESSION                            NO
TESTE_ORCL                      ALTER SYSTEM                             NO
TESTE_ORCL                      CREATE SEQUENCE                          NO
TESTE_ORCL                      CREATE TABLE                             NO
TESTE_ORCL                      MANAGE TABLESPACE                        NO
TESTE_ORCL                      EXECUTE ANY PROCEDURE                    NO
TESTE_ORCL                      CREATE TRIGGER                           NO
TESTE_ORCL                      CREATE VIEW                              NO
TESTE_ORCL                      SELECT ANY TABLE                         NO
TESTE_ORCL                      UNLIMITED TABLESPACE                     NO
TESTE_ORCL                      CREATE SESSION                           NO
TESTE_ORCL                      SELECT ANY DICTIONARY                    NO
TESTE_ORCL                      CREATE PROCEDURE                         NO

13 rows selected.

SYS@ORCL > SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE 'TESTE_ORCL';

GRANTEE PRIVILEGE ADM

------------------------------ ---------------------------------------- ---

TESTE_ORCL ALTER SESSION NO

TESTE_ORCL ALTER SYSTEM NO

TESTE_ORCL CREATE SEQUENCE NO

TESTE_ORCL CREATE TABLE NO

TESTE_ORCL MANAGE TABLESPACE NO

TESTE_ORCL EXECUTE ANY PROCEDURE NO

TESTE_ORCL CREATE TRIGGER NO

TESTE_ORCL CREATE VIEW NO

TESTE_ORCL SELECT ANY TABLE NO

TESTE_ORCL UNLIMITED TABLESPACE NO

TESTE_ORCL CREATE SESSION NO

TESTE_ORCL SELECT ANY DICTIONARY NO

TESTE_ORCL CREATE PROCEDURE NO

13 rows selected.

SYS@ORCL > select * from (
select 'GRANT '||privilege||' TO '||grantee||';' from dba_sys_privs
where grantee in ('TESTE_ORCL')
union all
select 'grant '||privilege||' on '||grantor||'.'||table_name||' to '||grantee||';' from dba_tab_privs
where grantee in ('TESTE_ORCL')
union all
select 'GRANT '||GRANTED_ROLE||' TO '||grantee||';' from dba_role_privs
  9  where grantee in ('TESTE_ORCL'));
----------------------------------------------------------------------
GRANT ALTER SESSION TO TESTE_ORCL;
GRANT ALTER SYSTEM TO TESTE_ORCL;
GRANT CREATE SEQUENCE TO TESTE_ORCL;
GRANT CREATE TABLE TO TESTE_ORCL;
GRANT MANAGE TABLESPACE TO TESTE_ORCL;
GRANT EXECUTE ANY PROCEDURE TO TESTE_ORCL;
GRANT CREATE TRIGGER TO TESTE_ORCL;
GRANT CREATE VIEW TO TESTE_ORCL;
GRANT SELECT ANY TABLE TO TESTE_ORCL;
GRANT UNLIMITED TABLESPACE TO TESTE_ORCL;
GRANT CREATE SESSION TO TESTE_ORCL;
GRANT SELECT ANY DICTIONARY TO TESTE_ORCL;
GRANT CREATE PROCEDURE TO TESTE_ORCL;
GRANT CONNECT TO TESTE_ORCL;

14 rows selected.

SYS@ORCL > select * from (

select 'GRANT '||privilege||' TO '||grantee||';' from dba_sys_privs

where grantee in ('TESTE_ORCL')

union all

select 'grant '||privilege||' on '||grantor||'.'||table_name||' to '||grantee||';' from dba_tab_privs

where grantee in ('TESTE_ORCL')

union all

select 'GRANT '||GRANTED_ROLE||' TO '||grantee||';' from dba_role_privs

9 where grantee in ('TESTE_ORCL'));

----------------------------------------------------------------------

GRANT ALTER SESSION TO TESTE_ORCL;

GRANT ALTER SYSTEM TO TESTE_ORCL;

GRANT CREATE SEQUENCE TO TESTE_ORCL;

GRANT CREATE TABLE TO TESTE_ORCL;

GRANT MANAGE TABLESPACE TO TESTE_ORCL;

GRANT EXECUTE ANY PROCEDURE TO TESTE_ORCL;

GRANT CREATE TRIGGER TO TESTE_ORCL;

GRANT CREATE VIEW TO TESTE_ORCL;

GRANT SELECT ANY TABLE TO TESTE_ORCL;

GRANT UNLIMITED TABLESPACE TO TESTE_ORCL;

GRANT CREATE SESSION TO TESTE_ORCL;

GRANT SELECT ANY DICTIONARY TO TESTE_ORCL;

GRANT CREATE PROCEDURE TO TESTE_ORCL;

GRANT CONNECT TO TESTE_ORCL;

14 rows selected.

Deixe um comentário Cancelar resposta