Aqua Data Studio Query Analyzer permissions based on server types and server connections, allow users to prevent catastrophic mistakes by restricting what type of SQL statements may be executed in the query window by a user.

A user may set default application permissions for production, development and test servers which will automatically set permissions when registering new server. Permissions may then be customized per server in the Server Registration dialog's permission tab. If the user attempts to execute an SQL statement that he does not have permissions for, then an error message will be displayed in the results indicating that he does not have permissions to do so.

Default Permissions are defined in File->Options->Permissions to set the default permissions by server type. The Server Registration dialog contains permissions tab to specify Query Analyzer permissions. Permissions are set by selecting Server Type, and are modifiable after server selection.

Permissions:

• Allows SELECT Statements - Determines whether SELECT statements may be executed in the Query Analyzer window for this server connection.
• Allows INSERT Statements - Determines whether INSERT statements may be executed in the Query Analyzer window for this server connection.
• Allows UPDATE Statements - Determines whether UPDATE statements may be executed in the Query Analyzer window for this server connection.
• Allows DELETE Statements - Determines whether DELETE statements may be executed in the Query Analyzer window for this server connection.
• Allows TRUNCATE Statements - Determines whether TRUNCATE statements may be executed in the Query Analyzer window for this server connection.
• Allows DDL Statements - Determines whether DDL (CREATE/ALTER/DROP) statements may be executed in the Query Analyzer window for this server connection.
• Allows All Ohter SQL Statements - Determines whether SQL statements other then SELECT, INSERT, UPDATE, DELETE, TRUNCATE, CREATE, ALTER or DROP may be executed in the Query Analyzer window for this server connection.
• Visual Editing: Allows CREATEs: Determines whether CREATEs are allowed for objects for servers.
  
• Visual Editing: Allows ALTERs: Determines whether ALTERs are allowed for objects for servers.
  
• Visual Editing: Allows DROPs: Determines whether DROPs are allowed for objects for servers.
  
• Visual Editing: Allows View Properties: Determines whether Viewing Properties for objects is allowed for servers.
  
• Table Data Editor: Allow Open Window: Determines whether opening Table Data Window is allowed for this server connection
  
• Table Data Editor: Allow INSERTs: Determines whether INSERTs are allowed for objects for servers
  
• Table Data Editor: Allow UPDATEs: Determines whether UPDATEs are allowed for objects for servers
  
• Table Data Editor: Allow DELETEs: Determines whether DELETEs are allowed for objects for servers
• Table Data Editor: Allow Primary Key definition changes: Determines whether Primary Key definitions can be changed for servers.