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