Post reply

Only grant access to a single view

  • June 10, 2010 at 8:35 pm

    #387131

    Hello,

    The only ability I would like to grant a user is access to a single view in a database. I gave them public access to the server and database and the explicit SELECT permission on the view, but they're claiming they can't see it.

    BTW, they're attempting to access it via an Excel 2003 SQL data connection.

    Thanks in advance!

    Steve

  • June 10, 2010 at 9:23 pm

    #1179005

    You can use SETUSER as an admin to check.

    Public shouldn't have rights, so be sure there's no deny on that, and check their permissions. If you can't find anything, you can also get a list of permissions for a user with fn_my_permissions

    http://blog.sqlauthority.com/2007/10/23/sql-server-get-permissions-of-my-username-userlogin-on-server-database/

  • June 14, 2010 at 9:53 pm

    #1180181

    Thanks for the tip - I used SETUSER to test out the access level needed. Turns out all I needed to do was give them SELECT permissions to the view itself and public access to the database containing the view as well as any databases referenced by it.

    Steve

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply