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

Example 24.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');