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 )

Registration Defaults

  • Amazon Redshift
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • Amazon Athena
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Apache Cassandra
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Apache Derby
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Apache Hive
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • DB2 - LUW 7.x
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • DB2 - LUW 8.x/9.x/10.x
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • DB2 - iSeries
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • DB2 - z/OS
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Generic - JDBC/ODBC
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Google BigQuery
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Greenplum
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Informix
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • InterBase
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • Microsoft Access Generic ODBC
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • Microsoft Excel Generic ODBC
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • MS Database Warehouse Azure Synapse 
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • MS Database Azure Synapse Serverless
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • MS Excel
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • MS SQL Database (Azure)
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • MS SQL Server and Amazon RDS
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • MS SQL Server 7.0
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • MariaDB
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • MongoDB
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • MongoDB Atlas
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • MySQL
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Netezza
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Oracle and Amazon RDS
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Oracle OCI
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • ParAccel Analytic Platform
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • PostgreSQL
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • SAP HANA
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • SingleStore MemSQL Database
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.

  • Snowflake
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • SQLite
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Sybase ASE 11/12/15/16
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Sybase Anywhere
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Sybase IQ
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Teradata Database
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Teradata Aster Database
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • Vertica
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.
     
  • VoltDB
    Driver Parameter: Defines Default Driver Parameter String for Server Registration.


  • No labels