MANAGE REPLICATION System Privilege

Required to perform replication-related tasks.

The MANAGE REPLICATION system privilege allows a user to:

  • Issue the CREATE, ALTER, DROP, or COMMENT PUBLICATION statement
  • Issue the CREATE, ALTER, DROP, or SYNCHRONIZATION SUBSCRIPTION statement
  • Issue the CREATE, ALTER, DROP, or SYNCHRONIZATION USER statement
  • Issue the CREATE, ALTER, DROP, or COMMENT SYNCHRONIZATION PROFILE statement
  • Issue the CREATE or DROP SUBSCRIPTION statement
  • Issue the CREATE REMOTE MESSAGE TYPE statement
  • Issue the DROP REMOTE MESSAGE TYPE statement
  • Issue the GRANT or REVOKE CONSOLIDATE statement
  • Issue the GRANT or REVOKE REMOTE statement
  • Issue the GRANT or REVOKE PUBLISH statement
  • Issue the LOCK FEATURE statement
  • Issue the START, STOP, or SYNCHRONIZE SUBSCRIPTION statement
  • Issue the PASSSTHROUGH statement
  • Issue the REMOTE RESET statement
  • Issue the SET REMOTE OPTION statement
  • Issue the START or STOP SYNCHRONIZATION SCHEMA CHANGE statement
  • Issue the SYNCHRONIZE PROFILE statement
  • Execute the SA_SETREMOTEUSER procedure
  • Execute the SA_SETSUBSCRIPTION procedure
Grant this system privilege using the WITH ADMIN OPTION, WITH NO ADMIN OPTION, or WITH ADMIN ONLY OPTION clause. If you do not specify a clause, the default is WITH NO ADMIN OPTION.
Parent topic: Replication System Privileges
Related reference
List All System Privileges