Thursday, February 6, 2014

Which privileges are needed to execute DBMS_REDEFINITION package?

Execute privileges on the DBMS_REDEFINITION package are granted to EXECUTE_CATALOG_ROLE.

In addition to having execute privileges on this package, you must be granted the following privileges:

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

    In addition, the following privileges are required to execute COPY_TABLE_DEPENDENTS procedure:

  • CREATE ANY TRIGGER
  • CREATE ANY INDEX

    Source: Oracle Documentation
  • No comments:

    Post a Comment