solidDB Help : solidDB reference : SQL: Statements : REVOKE REFRESH
  
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
SQL: Statements