solidDB Help : solidDB reference : SQL: Statements : GRANT REFRESH
  
GRANT REFRESH
Note Applies to only solidDB Advanced Replication configurations.
GRANT REFRESH ON publication‑name TO {PUBLIC | user‑name [, user‑name …] |
   role‑name [, role‑name …]}
Access requirements
In master: DBA or creator of the publication
Usage
This GRANT REFRESH statement grants access rights on a publication to a user or role that is defined in the master database.
The GRANT REFRESH statement can only be executed on the master database.
Note The keyword REFRESH is equivalent to the deprecated keyword SUBSCRIBE.
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;
Go up to
SQL: Statements