Home Forums SQL Server 2008 SQL Server 2008 - General How to give a user ONLY permission to a view, and nothing else in the database RE: How to give a user ONLY permission to a view, and nothing else in the database

  • October 31, 2012 at 2:30 pm

    #1554779

    Thanks everybody for chiming in...I finally got it to work by this;

    Created the view

    Went to the view/properties/permissions/ in SMS..find the user that you want to have access...then choose grant for "select" under permissions...thats it.