Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_FGA , 3 of 5
This procedure drops an audit policy.
DBMS_FGA.DROP_POLICY( object_schema VARCHAR2, object_name VARCHAR2, policy_name VARCHAR2 );
Parameter | Description |
---|---|
object_schema |
The schema of the object to be audited |
object_name |
The name of the object to be audited |
policy_name |
The unique name of the policy |
The DBMS_FGA
procedures cause current DML transactions, if any, to commit before the operation. However, the procedures do not cause a commit first if they are inside a DDL event trigger. With DDL transactions, the DBMS_FGA
procedures are part of the DDL transaction.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|