Revoking REMOTE DBA authority removes the user's ability to have full DBA authority on the database when connected from SQL Remote. See Grant REMOTE DBA authority.
Use the following procedure to revoke REMOTE DBA authority from a user.
Connect to the database as a user with DBA authority.
In the left pane, select either the Users & Groups folder or the SQL Remote Users folder.
Right-click the user and choose Properties.
Click the Authorities tab and clear the Remote DBA option.
Click OK.
Connect to the database as a user with DBA authority.
Execute a REVOKE REMOTE DBA statement to revoke REMOTE DBA authority from a user.
For example:
REVOKE REMOTE DBA FROM dbremote; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |