TAILIEUCHUNG - Oracle Built−in Packages- P132

Oracle Built−in Packages- P132: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Oracle8 Revokes privileges required to administer all replication schemas REVOKE_ADMIN_REPGROUP Revokes privileges required to administer the replication group for which the user is the schema owner No REVOKE_ADMIN_REPSCHEMA Oracle8 Revokes privileges required to administer the replication schema for which the user is the schema owner. No DBMS_REPCAT_ADMIN exceptions The DBMS_REPCAT_ADMIN package may raise exception ORA-1917 if the specified user does not exist. NOTE Oracle8 documents only the REPGROUP procedures although the REPSCHEMA procedures also exist. The functionality is identical. Creating and Dropping Replication Administrator Accounts Advanced replication also requires an account to maintain the environment. The replication administrator account usually REPADMIN performs tasks such as quiescing the environment adding and removing master sites and creating replication groups. For example you ll use DBMS_REPCAT s procedure to set up the replication administrator account to maintain all replication groups in your environment. You can also configure an account to control exactly one schema in a replication group with the GRANT_ADMIN_REPGROUP procedure. The recipient of this grant will be able to perform administrative tasks on objects it owns within a replication group the account will not be able to administer objects it does not own. Because of this restriction it usually makes sense to create administrative accounts for a specific group only if it is a single schema replication group and the administrative account is the schema account. In most cases the DBA opts for using a single replication administrator account over creating administrative accounts for every replication group. The procedure The GRANT_ADMIN_REPGROUP procedure grants the privileges required to administer a replication group for which the user is the .

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản