Đang chuẩn bị liên kết để tải về tài liệu:
Rampant TechPress Oracle Data Warehouse Management PHẦN 10

Cú pháp của thủ tục VALIDATE_PENDING_AREA: Thủ tục VALIDATE_PENDING_AREA được sử dụng để xác nhận các nội dung của một khu vực đang chờ giải quyết trước khi trình. Thủ tục không có đối số. DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA; | ROBO Books Monograph Data Warehousing and Oracle8i Syntax for the DROP POLICY Procedure DBMS_RLS.DROP_POLICY object_schema IN VARCHAR2 NULL object_name IN VARCHAR2 policy_name IN VARCHAR2 Where object_schema - Schema containing the table or view logon user if NULL . object_name - Name of table or view. policy_name - Name of policy to be dropped from the table or view. Syntax for the REFRESH POLICY Procedure DBMS_RLS.REFRESH_POLICY object_schema IN VARCHAR2 NULL object_name IN VARCHAR2 NULL policy_name IN VARCHAR2 NULL Where object_schema - Schema containing the table or view. object_name - Name of table or view that the policy is associated with. policy_name - Name of policy to be refreshed. Syntax for the ENABLE POLICY Procedure DBMS_RLS.ENABLE_POLICY object_schema IN VARCHAR2 NULL object_name IN VARCHAR2 policy_name IN VARCHAR2 enable IN BOOLEAN Where object_schema - Schema containing the table or view logon user if NULL . object_name - Name of table or view that the policy is associated with. policy_name - Name of policy to be enabled or disabled. Page 110 COPYRIGHT 2003 Rampant TechPress. All Rights Reserved. ROBO Books Monograph Data Warehousing and Oracle8i Enable - TRUE to enable the policy FALSE to disable the policy. Through the use of the above procedures DBAs and developers can easily manage policies. Summary Oracle has given DBAs and developers a powerful new tool to manage row level security. This new tool is a combination of contexts triggers and packages and a new package named DBMS_RLS through which security policies are implemented. Through the proper use of policies contexts packages and database level triggers row level security can be easily integrated in Oracle8i applications. The above lesson was excerpted from the soon to be released book Oracle8i Administration and Management Michael R. Ault John Wiley and Sons Publishers . Page 111 COPYRIGHT 2003 Rampant TechPress. All Rights Reserved. ROBO Books Monograph Data Warehousing and Oracle8i Hour