Most SQL Server databases have a number of users viewing and accessing data, which makes security a concern for the administrator.
The smart administrator will take full advantage of SQL Server security roles, which grant and deny permissions to groups of users, greatly reducing the security workload.
The first step in protecting your data is determining which users need to view which data and then allowing access to only those users.
You must also decide which users can change the data. For example, although someone in fulfillment might need to verify a customer’s address, you may want only an account executive or a specially trained data entry clerk to change that account’s address.
User Types
Admin |
Has full access to all or most Tradar Functions |
User |
Has limited access to necessary Tradar Functions |
User Roles
Tradar ships with three default User Roles - Admin, UserLevel1 and UserLevel2
Editing an existing User Role |
Click the blue edit icon to edit the Admin User Roles |
Role Description |
This is the name of the User Role |
Each different function has three levels that can be assigned to it. These can be selected from the drop down box next to each function. In the above example the Admin User has full access to all of Tradars functions.
None |
User can not access this function |
Read |
User can view this function but not change it |
Full |
User has full access and control over this function |
Adding a User Role |
Roles may be added to enable staff or other people to access Tradar without full Admin functionality. Once roles are created these can be assigned to Users in the Add/Maintain Users menu.
To Add a Role: Admin > Add Maintain Users > Add/Edit Role > Add a Role |
In the example above we have created a user role Customer Care Consultant.
The access levels selected enables users with this role assigned to them to manage the data (sales & customer maintenance), to view (but not modify) Products, Suppliers etc, and to have no access to restoring the database.
Multiple different roles can be set up and assigned to varying users according to business requirements.