jueves, 28 de octubre de 2010

ORACLE FGA

DESHABILITAR QUE EL USUARIO NO LE APLIQUEN LAS POLITICAS DE FGA

SQL> REVOKE EXEMPT ACCESS POLICY FROM HR;

Revoke succeeded.

SQL> GRANT EXEMPT ACCESS POLICY TO HR;

Grant succeeded.

SQL> REVOKE EXEMPT ACCESS POLICY FROM HR;

Revoke succeeded.

SQL> SELECT * FROM DBA_SYS_PRIVS WHERE PRIVILEGE LIKE '%EXE%';