SQL Guide : solidDB® SQL statements : REVOKE REFRESH
  
REVOKE REFRESH
REVOKE { REFRESH | SUBSCRIBE} ON publication_name
   FROM {PUBLIC | user_name, [ user_name ] ... |
   role_name , [ role_name ] ...}
Usage
The REVOKE REFRESH statement revokes access rights to a publication from a user or role defined in the master database. The REVOKE REFRESH statement is applicable only in advanced replication configurations. It can only be issued on the master database.
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;
See also
solidDB® SQL statements