|
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.
|
|
