进行表的在线重定义时所需要的权限

刘泽宇

Execute privileges on the DBMS_REDEFINITION package are required to run subprograms in the package. Execute privileges on the DBMS_REDEFINITION package are granted to EXECUTE_CATALOG_ROLE.

In addition, for a user to redefine a table in the user's schema using the package, the user must be granted the following privileges:

• CREATE TABLE
• CREATE MATERIALIZED VIEW
  
  

The CREATE TRIGGER privilege is also required to execute the COPY_TABLE_DEPENDENTS procedure.

For a user to redefine a table in other schemas using the package, the user must be granted the following privileges:

• CREATE ANY TABLE
• ALTER ANY TABLE
• DROP ANY TABLE
• LOCK ANY TABLE
• SELECT ANY TABLE
  
  

The following additional privileges are required to execute COPY_TABLE_DEPENDENTS on tables in other schemas:

• CREATE ANY TRIGGER
• CREATE ANY INDEX