GRANT REFRESH

SQL Guide : solidDB® SQL statements : GRANT REFRESH

GRANT REFRESH

GRANT REFRESH ON publication_name TO {PUBLIC | user_name,
[ user_name ] ... | role_name , [ role_name ] ...}

Usage

This GRANT REFRESH statement grants access rights on a publication to a user or role defined in the master database. The GRANT REFRESH statement applies only to advanced replication configurations and it can only be executed on the master database.

Note The keyword REFRESH can used to be equivalent to the keyword SUBSCRIBE; however, the keyword SUBSCRIBE has been deprecated in the GRANT statement.

Return values

Error Code	Description
13137	Illegal grant/revoke mode
13048	No grant option privilege
25010	Publication name not found

Examples

GRANT REFRESH ON customers_by_area TO salesman_jones; GRANT REFRESH ON customers_by_area TO all_salesmen;