Administrators need to be aware of the how Microsoft SQL Server privileges for users are managed within DataSight. We can group DataSight users or administrators into four different categories.
|
User Category |
Limited User |
Standard User |
Advanced User |
Administrator |
|
Functions permitted |
Limited e.g. Browse data Use Reports Create Charts Use Calculations |
Standard e.g. Browse data User Reports Import data Create and modify Saved Views Use Calculations Create and modify levels Save Calculation templates Save Conversion Tables |
All e.g. Browse data User Reports Import data Create and modify Saved Views Use Calculations Create and modify Levels Save Calculation templates Save Conversion Tables Create and modify Variables Design Reports Perform DataSight upgrades Set DataSight accounts |
All e.g. Browse data User Reports Import data Create and modify Saved Views Use Calculations Create and modify Levels Save Calculation templates Save Conversion Tables Create and modify Variables Design Reports Create databases Perform DataSight upgrades Set DataSight accounts Backup databases MS SQL Server Administrator |
|
Functions denied |
Import data Modify Saved views Create and modify Levels Save Calculation templates Save Conversion Tables Create and modify Variables Design Reports Perform DataSight upgrades |
Create and modify Variables Design Reports Perform DataSight upgrades
|
MS SQL Server Administrator |
|
|
Database structure |
Cannot be altered |
Cannot be altered |
Cannot be altered |
Can be altered |
|
Data |
Cannot be altered |
Can be altered |
Can be altered |
Can be altered |
|
Microsoft SQL Server permissions |
Read write on a specific database |
Read write on a specific database |
dbo owner |
System Administrator |
|
Authentication |
Windows or MS SQL |
Windows or MS SQL |
Windows or MS SQL |
Windows or MS SQL |