Managing instance-level administrative security
Each Analysis Services instance has one server role reserved for administrators. All members of this role have unrestricted access to all objects on the instance. Membership in the administrator role is mandatory to perform the following operations:
- Create and drop databases
- Collect traces against multiple databases on the same instance in a single trace
- Stop/restart the instance
- Backup/restore databases
- Modify server configuration settings
- Grant server-level administrator permissions
- Detach/attach databases
- Synchronize databases (requires administrative permissions to both source and target instances)
How to do it...
To add members to the server administrator role, perform the following steps:
- Connect to the ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
