Types of user roles

The Warehouse Administration Console has three user roles that grant distinct privileges to different functions in the Warehouse Administration Console. The user roles are the Administrator, Operator, and Viewer.

Each user role has different privileges based on the component:

SQL Warehousing
Cubing Services
Mining
Configuration

The Administrator is a super user and can do all the functions that are available in each component. The privileges that are granted to each user role are described in the following tables.

Administrator: A user who is assigned the Administrator role is a super user and can do any task in the Administration Console. The Administrator role has the following privileges in addition to the Operator privileges: add, edit, and delete any connection or system resource, including connections and system resources that are private and owned by other users.
Operator: A user who is assigned the Operator role does operational tasks, such as deploying applications and running control flows. The Operator role has the following privileges in addition to the Viewer privileges: add, edit, and delete any connection or system resource excluding private connections that the operator does not own.
Viewer: A user who is assigned the Viewer role can do system monitoring. The Viewer can view most of the status information in the Administration Console but does not have the privileges to change any parameters or settings. A user who is assigned the Viewer role can view any public connection or system resource, or a private connection or system resource that the Viewer is granted access to by an Operator or Administrator. A user who is assigned the Viewer role cannot add a connection or system resource.

The privileges that are granted to each user role are described in the following tables.

SQL Warehousing privileges

The privileges for the SQL Warehousing component are described in the following table.

Table 1. SQL Warehousing user role privileges by object
Object	Viewer	Operator	Administrator
Applications	View the Manage Application page View details Refresh	In addition to the Viewer privileges, the Operator also has privileges to: Deploy Deploy changes Enable Disable Delete	The Administrator has the same privileges as the Operator.
Control flows	View the Manage Control Flows page View the Log View statistics Refresh	In addition to the Viewer privileges, the Operator also has privileges to: Run Manage schedules Manage profiles View details	The Administrator has the same privileges as the Operator.
Instances	View the Manage Instances page Monitor View the log View statistics View details Refresh	In addition to the Viewer privileges, the Operator also has privileges to: Stop Restart Delete	The Administrator has the same privileges as the Operator.

Cubing Services privileges

The privileges for the Cubing Services component are described in the following table.

Table 2. Cubing Services user role privileges by object
Object	Viewer	Operator	Administrator
Cube servers	View the Manage Cube Servers page View the Manage the XMLA Service page Query status	In addition to the Viewer privileges, the Operator also has privileges to: Start Stop Restart Manage cubes	In addition to the Operator privileges, the Administrator has privileges to: Create Edit Delete
OLAP metadata	View the Manage OLAP Metadata page	In addition to the Viewer privileges, the Operator also has privileges to: View the Summary Table Usage page Optimize Run SQL	In addition to the Operator privileges, the Administrator has privileges to: Import cube models Import security Edit cube models Delete
Cubing Services roles	View the Manage Cubing Services Role page View privileges	The Operator has the same privileges as the Viewer.	In addition to the Operator privileges, the Administrator has privileges to: Create Edit Delete Manage users

Mining privileges

The privileges for the Mining component are described in the following table.

Table 3. Mining user role privileges by object
Object	Viewer	Operator	Administrator
Database enablement	View the Enable Database page View status Refresh	The Operator has the same privileges as the Viewer.	In addition to the Operator privileges, the Administrator has privileges to: Enable
Mining models	View the Manage Mining Models page View	In addition to the Viewer privileges, the Operator also has privileges to: Export	In addition to the Operator privileges, the Administrator has privileges to: Import Update Delete Cache
Cached mining models	View the Manage Cached Mining Models page	In addition to the Viewer privileges, the Operator also has privileges to: Reset the cache size Remove Remove all	The Administrator has the same privileges as the Operator.

Configuration privileges

The privileges for configuring system notification and logging in the Warehouse Administration Console are described in the following list.

Viewers: Viewers can view the Configuration page and do a refresh.
Operators: Operators have the same privileges as Viewers.
Administrators: Administrators can configure system notification and logging.

Feedback