Revoking a user's REMOTE permission:
Removes a user from the SQL Remote system.
Reverts that user or group to a normal user/group.
Unsubscribes the user or group from all publications.
Connect to the database as a user with DBA authority.
In the left pane, expand either the Users & Groups folder or the SQL Remote Users folder.
Right-click the remote user or group and choose Revoke Remote.
Connect to the database as a user with DBA authority.
Execute a REVOKE REMOTE statement to revoke the REMOTE permission from the current user or group. See REVOKE REMOTE statement [SQL Remote].
For example, the following statement revokes REMOTE permission from user S_Beaulieu.
REVOKE REMOTE FROM S_Beaulieu; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |