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.