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

SQL Anywhere 12.0.0 (Français) » SQL Remote » Creating SQL Remote systems » User permissions » Granting REMOTE DBA authority

 

Grant REMOTE DBA authority

 ♦  To grant 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, select either the Users & Groups folder or the SQL Remote Users folder.

  3. Right-click the user and choose Properties.

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

  5. Click Apply and then click OK.

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

  2. Execute a GRANT REMOTE DBA statement to grant REMOTE DBA authority to a user.

    For example:

    GRANT REMOTE DBA TO dbremote
    IDENTIFIED BY dbremote;
 See also