Permissions and Registration Options

Permissions

• Default Production Server Permissions
  
  Query Analyzer: Allows SELECT Statements: Determines whether SELECT statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows INSERT Statements: Determines whether INSERT statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows UPDATE Statements: Determines whether UPDATE statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows DELETE Statements: Determines whether DELETE statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows TRUNCATE Statements: Determines whether TRUNCATE statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows DDL Statements: Determines whether DDL (CREATE/ALTER/DROP) statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows All Other SQL Statements: Determines whether SQL statements other than 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 this server connection.
  Visual Editing: Allows ALTERs: Determines whether ALTERs are allowed for objects for this server connection.
  Visual Editing: Allows DROPs: Determines whether DROPs are allowed for objects for this server connection.
  Visual Editing: Allows View Properties: Determines whether Viewing Properties for objects is allowed for this server connection.
  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 rows for this server connection.
  Table Data Editor: Allow UPDATEs: Determines whether UPDATEs are allowed for data for this server connection.
  Table Data Editor: Allow DELETEs: Determines whether DELETEs are allowed for data for this server connection.
  Table Data Editor: Allow Primary Key definition changes: Determines whether the Table Data Editor allows Primary Key definitions changes.
  SQL Debugger: Allow Debugging: Determines whether SQL debugging is enabled for this server connection ( only possible on SQL Server, Sybase ASE, Oracle, DB2 LUW )


• Default Development Server Permissions
  
  Query Analyzer: Allows SELECT Statements: Determines whether SELECT statements may be executed in the Query Analyzer window for Development servers.
  Query Analyzer: Allows INSERT Statements: Determines whether INSERT statements may be executed in the Query Analyzer window for Development servers.
  Query Analyzer: Allows UPDATE Statements: Determines whether UPDATE statements may be executed in the Query Analyzer window for Development servers.
  Query Analyzer: Allows DELETE Statements: Determines whether DELETE statements may be executed in the Query Analyzer window for Development servers.
  Query Analyzer: Allows TRUNCATE Statements: Determines whether TRUNCATE statements may be executed in the Query Analyzer window for Development servers.
  Query Analyzer: Allows DDL Statements: Determines whether DDL (CREATE/ALTER/DROP) statements may be executed in the Query Analyzer window for Development servers.
  Query Analyzer: Allows All Other 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 Development servers.
  Visual Editing: Allows CREATEs: Determines whether CREATEs are allowed for objects for Development servers.
  Visual Editing: Allows ALTERs: Determines whether ALTERs are allowed for objects for Development servers.
  Visual Editing: Allows DROPs: Determines whether DROPs are allowed for objects for Development servers.
  Visual Editing: Allows View Properties: Determines whether Viewing Properties for objects is allowed for Development 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 Development servers
  Table Data Editor: Allow UPDATEs: Determines whether UPDATEs are allowed for objects for Development servers
  Table Data Editor: Allow DELETEs: Determines whether DELETEs are allowed for objects for Development servers
  Table Data Editor: Allow Primary Key definition changes: Determines whether Primary Key definitions can be changed for servers
  SQL Debugger: Allow Debugging: Determines whether SQL Debugging is enabled for Development Servers ( only possible on SQL Server, Sybase ASE, Oracle, DB2 LUW )


• Default Test Server Permissions
  
  Query Analyzer: Allows SELECT Statements: Determines whether SELECT statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows INSERT Statements: Determines whether INSERT statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows UPDATE Statements: Determines whether UPDATE statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows DELETE Statements: Determines whether DELETE statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows TRUNCATE Statements: Determines whether TRUNCATE statements may be executed in the Query Analyzer window for this server connection.
  Query Analyzer: Allows DDL Statements: Determines whether DDL (CREATE/ALTER/DROP) statements may be executed in the Query Analyzer window for Test servers.
  Query Analyzer: Allows All Other SQL Statements: Determines whether SQL statements other than 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 this server connection.
  Visual Editing: Allows ALTERs: Determines whether ALTERs are allowed for objects for this server connection.
  Visual Editing: Allows DROPs: Determines whether DROPs are allowed for objects for this server connection.
  Visual Editing: Allows View Properties: Determines whether Viewing Properties for objects is allowed for this server connection.
  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 rows for this server connection.
  Table Data Editor: Allow UPDATEs: Determines whether UPDATEs are allowed for data for this server connection.
  Table Data Editor: Allow DELETEs: Determines whether DELETEs are allowed for data for this server connection.
  Table Data Editor: Allow Primary Key definition changes: Determines whether the Table Data Editor allows Primary Key definition changes.
  SQL Debugger: Allow Debugging: Determines whether SQL debugging is enabled for this server connection. ( only possible on SQL Server, Sybase ASE, Oracle, DB2 LUW )