Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Remote » Creating SQL Remote systems » User permissions » REMOTE DBA authority

 

Revoke REMOTE DBA authority

Revoking REMOTE DBA authority removes the user's ability to have full DBA authority on the database when connected from SQL Remote.

Use the following procedure to revoke REMOTE DBA authority from a user.

 Revoke REMOTE DBA authority (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

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

  3. Right-click the user and click Properties.

  4. Click the Authorities tab and clear the Remote DBA option.

  5. Click OK.

 Revoke REMOTE DBA authority (SQL)
  1. Connect to the database as a user with DBA authority.

  2. Execute a REVOKE REMOTE DBA statement to revoke REMOTE DBA authority from a user.

    For example:

    REVOKE REMOTE DBA FROM dbremote;
 See also