A_MSSQL_GRANT_PERMISSIONS

This configuration variable specifies what permissions to grant to a newly created table. Using standard SQL syntax, insert the value of this variable into the GRANT statement. The default value is select, insert, delete, update.

Notes:
  • The default value of this variable allows for unchanged behavior from previous versions.
  • If this and/or the A_MSSQL_GRANT_USERNAME configuration variable value is empty, the GRANT statement is not executed when a new table is created. In this case, your DBA controls permissions from SQL Server. See your SQL Server documentation for details.