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;
See also
solidDB® SQL statements