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