Granting Additional Rights for Specific Tasks
Collapse the table of content
Expand the table of content

Granting Additional Rights for Specific Tasks

If you need to use the logon account to Microsoft SQL Server Analysis Services either to access a backup file or to work with the query log table in a specific Microsoft SQL Server database, there are additional rights that you must grant to the logon account.

The Analysis Services logon account requires the following permissions to access a backup file:

  • To perform a database backup, the Analysis Services logon account must have file level permissions to create the backup file in the specified location.

  • To perform a database restoration, the Analysis Services logon account must have read permissions to the backup file.

Additionally, use the NTFS file system to help secure the storage location for the backup file and to help make sure that unauthorized users do not have access to the backup file.

The Analysis Services logon account must have write permissions to the query log table in the designated SQL Server database. If this table does not already exist and needs to be created, the Analysis Services logon account must also have create table permissions within the designated SQL Server database.

NoteNote

Security on the query log table is the responsibility of the SQL Server database administrator.

If writeback is enabled within any dimension or cube, the Analysis Services logon account must have write permissions to the writeback table in the designated SQL Server database. If this table does not already exist and needs to be created, the Analysis Services logon account must also have create table permissions within the designated SQL Server database.

NoteNote

Security on the writeback table is the responsibility of the SQL Server database administrator.

Community Additions

ADD
Show:
© 2016 Microsoft