locked
To which group must a uer of SQL Analysis Services belong ? RRS feed

  • Question

  • To which group must a user of SQL Analysis Services 2005 belong ?
    So somebody
    using SQL ServerBusiness Intelligence Studio.
    I want to avoid to grand rights of the Administrator group.
    During installation, so many groups are created, so I don´t know what to do.
    Any help ?!

    Scenario 1:
    Using SQL ServerBusiness Intelligence Studio, on the same computer as SQL Server 2005 is running ( e.g. WinXP)

    Scenario 2:
    Using  SQL ServerBusiness Intelligence Studio, on another computer as SQL Server 2005 is running ( e.g. WinXP client with VS2005pro, W2k Server with SQL Server 2005, connection by IAS Service)

    IAS Service = naming the login name and login password of the user of a certain computer, plus the name/ip address of the computer, in a table of W2k Server.

    Scenario 3:
    ? Well, anything with Active Directory ??

    Another question:
    Does a user of
    SQL Analysis Services have the right of a database administrator, e.g. creating tables ect, or any other rights, which are not necessary for standard SQL access by an application ( which usually just can read and write values, but shouldn't change or create tables) ?!

    Sincerely
    Rolf



    Wednesday, December 24, 2008 10:24 PM

Answers

  • To limit users and their access within SSAS you would create a Role in the actual SSAS database, setup the necessary permissions and access rights in the Role and then assign members or groups to the Role within Memberships.

    For basic access users will need to be able to read the definition of the SSAS database and they will also need Read access on the cube to be able to reference and query the data.
    Dan English -- http://denglishbi.spaces.live.com
    Friday, December 26, 2008 4:25 PM

All replies

  • You need to go to "Analysis Service Properties"->Security and add the users there. To limit what the users can do, you assign them different roles to an analysis service database.
    -- This posting is provided "AS IS" with no warranties, and confers no rights
    Friday, December 26, 2008 2:03 PM
    Answerer
  • To limit users and their access within SSAS you would create a Role in the actual SSAS database, setup the necessary permissions and access rights in the Role and then assign members or groups to the Role within Memberships.

    For basic access users will need to be able to read the definition of the SSAS database and they will also need Read access on the cube to be able to reference and query the data.
    Dan English -- http://denglishbi.spaces.live.com
    Friday, December 26, 2008 4:25 PM