Re: Audit in Oracle

My Oracle version is 9.2.0.1.0

User SA has DBA system role, so he can do most of things.
User SA connects to a database and executes the following command:
AUDIT GRANT ANY PRIVILEGE BY ACCESS
(Audit granted)

User ADMIN has only CONNECT system role, but I grant to him GRANT ANY
PRIVILEGE system privilege.
User ADMIN connects to a database and executes the command:
GRANT UNLIMITED TABLESPACE TO ANALITIC
(Grant succeeded)

User ANALITIC didn't have the privilege UNLIMITED TABLESPACE before and
now he got it.

Then I look to the DBA_AUDIT_TRAIL view and there is no record
describing the latest operation about granting this privilege. Though
there must be *two* records as I supposed.

.

Relevant Pages

  • Re: Privileges Issue
    ... I'd have no problem as the GRANT ANY OBJECT ... privilege would sort me out. ... another schema to a another seperate schema. ... let's say my schema with the DBA role is called Schema 1. ...
    (comp.databases.oracle.server)
  • Re: are the ALL_* views usually viewable by all users?
    ... Even a freshly created user with only CREATE SESSION privilege can ... execute DBMS_UTILITY.NAME_RESOLVE so no special privileges need be ... SQL> grant create session to blerp; ... Grant succeeded. ...
    (comp.databases.oracle.misc)
  • Re: system_privilege_map issue
    ... I can grant a user those privileges and the user can create the materialized view. ... SQL> select privilege, name ... -174 ALTER ANY SNAPSHOT ...
    (comp.databases.oracle.server)
  • Re: [SLE] mysql
    ... When Privilege Changes Take Effect ... all grant table contents are read into memory and become ... When the server reloads the grant tables, ... you either restart the server or tell it to reload the tables. ...
    (SuSE)