When you revoke CONSOLIDATE permission from a user, SQL Anywhere:
Removes the user from the SQL Remote system.
Reverts that user or group to a normal user/group.
Unsubscribes the user or group from all publications.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
Expand either the Users & Groups folder or the SQL Remote Users folder.
Right-click the consolidated user or group and click Revoke Consolidated.
Connect to the database as a user with DBA authority.
Execute a REVOKE CONSOLIDATE statement to revoke CONSOLIDATE permission from the current user or group.
REVOKE CONSOLIDATE FROM Cons_User;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|