SQL Manager

Clicking the SQL Manager button will open the Read/Write assignment wizard for SQL storage areas. This utility allows permissions to be set on data item types within storage areas.

NOTE: SQL Compatibility tools are need for SQL Manager to be able to function for SQL 2008, SQL 2012, and SQL 2014.

SQL Manager has been updated to allow setting of AccuMark data type read / write controls on a group level. In earlier software versions you could only set permissions on a user level. Create and use windows groups for users in different departments or working roles, then allocate permissions more efficiently per group compared to each individual user. Then simply add or remove users to the groups you set up rather than modifying their individual data type permissions.

Setting read and/or write access for users and now windows groups for the various AccuMark data types lets you control data creation and manipulation for SQL storage areas and subfolders. For example, allow pattern makers to read and write models and pieces, but only let marker makers read and use models and pieces to make their markers (assigning read-only permission will not let them make any modifications to the models and pieces).

Users are also better informed with the improved messages regarding when and what permission they have when accessing data and storage areas.