ECN-GL594 Better control of permissions granted on newly created tables

Product: Acu4GL

Module: MSSQL

Machines Affected: All

Versions Affected: All

DESCRIPTION:

When creating a table, the SQL Server interface also creates an index, and grants loose permissions to everyone via the A-MSSQL-GRANT-PERMISSIONS and A-MSSQL-GRANT-USERNAME configuration variables with their default values. If database permissions are not set to allow these loose permissions, the GRANT statement fails, causing OPEN OUTPUT to fail.

For details, see the following Configuration Variable topics in your Acu4GL User's Guide:

  • A-MSSQL-GRANT-PERMISSIONS
  • A-MSSQL-GRANT-USERNAME