System privilege required to perform replication-related tasks.
The MANAGE REPLICATION system privilege allows a user to:
- Issue CREATE, ALTER, DROP, or COMMENT PUBLICATION statement
- Issue CREATE, ALTER, DROP, or SYNCHRONIZATION SUBSCRIPTION statement
- Issue CREATE, ALTER, DROP, or SYNCHRONIZATION USER statement
- Issue CREATE, ALTER, DROP, or COMMENT SYNCHRONIZATION PROFILE statement
- Issue CREATE or DROP SUBSCRIPTION statement
- Issue CREATE REMOTE MESSAGE TYPE statement
- Issue DROP REMOTE MESSAGE TYPE statement
- Issue GRANT or REVOKE CONSOLIDATE statement
- Issue GRANT or REVOKE REMOTE statement
- Issue GRANT or REVOKE PUBLISH statement
- Issue LOCK FEATURE statement
- Issue START, STOP, or SYNCHRONIZE SUBSCRIPTION statement
- Issue PASSSTHROUGH statement
- Issue REMOTE RESET statement
- Issue SET REMOTE OPTION statement
- Issue START or STOP SYNCHRONIZATION SCHEMA CHANGE statement
- Issue SYNCHRONIZE PROFILE statement
- Execute SA_SETREMOTEUSER
- Execute SA_SETSUBSCRIPTION
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 WITH NO ADMIN OPTION
clause is used by default.