Name
REPL_GRANT — grant privileges for subscription to a publication
Synopsis
REPL_GRANT ( |
in publication varchar , |
in grantee varchar
); |
Description
This function is used to grant privilege for subscription to a SQL account for particular publication. The DBA accounts always have right for subscription to all available publications.
Parameters
publication
A publication account name.
grantee
A valid DB account name to be granted subscription rights.
Example
Example24.320.Granting access to 'table_publication' for SQL user account 'demo'.
This is to grant permissions for table_publication publication account to subscribe with a SQL user account 'demo'.
SQL> DB.DBA.REPL_GRANT ('table_publication', 'demo');