Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.1 (Français) » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » User permissions » REMOTE permission

 

Revoke REMOTE permission

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.

♦  To revoke REMOTE permission (Sybase Central)

  1. Connect to the database as a user with DBA authority.

  2. In the left pane, expand either the Users & Groups folder or the SQL Remote Users folder.

  3. Right-click the remote user or group and choose Revoke Remote.

♦  To revoke REMOTE permission (SQL)

  1. Connect to the database as a user with DBA authority.

  2. 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;
See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1