REVOKE REFRESH
Note Applies to only solidDB Advanced Replication configurations.
REVOKE {REFRESH | SUBSCRIBE} ON publication‑name
FROM {PUBLIC | user‑name [, user‑name …] | role‑name [, role‑name …]}
Access requirements
In master: DBA or creator of the publication
Usage
Use the REVOKE REFRESH statement to revoke access rights to a publication from a user or role that is defined in the master database.
The REVOKE REFRESH statement can be executed only on the master database.
Note The keywords REFRESH and SUBSCRIBE are synonymous. However, SUBSCRIBE is deprecated in the REVOKE statement.
Return values
Error code
|
Description
|
13137
|
Illegal grant/revoke mode
|
13048
|
No grant option privilege
|
25010
|
Publication name not found
|
Examples
REVOKE REFRESH ON customers_by_area FROM joe_smith; REVOKE REFRESH ON customers_by_area FROM all_salesmen;
Go up to