Your browser does not support JavaScript. This help page requires JavaScript to render correctly.
Previous
Previous
 
Next
Next

Grant Access to Replication Objects: Step 4

After configuring a multimaster replication environment, use the instructions in Executing DDL Within a Master Group to grant access to the various replication objects so that users that connect to each site can use them.

The following is an example of a grant statement:

GRANT SELECT ON hr.employees TO rsmith

Note: Do not include the terminating semi-colon (;) at the end of the DDL statement.

Related Topics

What Is Multimaster Replication?

Flowchart for Creating a Master Group