Give other users access to SQL database for refresh RRS feed

  • Question

  • Hi,

    How do I give guest rights for my database in SQL Express so that they can refresh data in PowerPivot?


    Wednesday, June 8, 2011 9:28 AM


  • You can create a windows user group and add those guests to the windows user group, and then create a login from that group and only grant SELECT permission to the user on the corresponding table.

    By this way you need to maintain the windows user group when there are new users who would like to access the data. If you want any people to access the data without your maintenance efforts, you may create a dedicated SQL login which only has SELECT permission to access the related table and save the login and password information in the Excel connection.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Thursday, June 9, 2011 9:59 AM