SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / How to give a user ONLY permission to a view, and nothing else in the database / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:00:59 GMT20RE: How to give a user ONLY permission to a view, and nothing else in the databasehttp://www.sqlservercentral.com/Forums/Topic1378528-391-1.aspxThanks everybody for chiming in...I finally got it to work by this;Created the viewWent 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.Wed, 31 Oct 2012 14:30:05 GMTkolnRE: How to give a user ONLY permission to a view, and nothing else in the databasehttp://www.sqlservercentral.com/Forums/Topic1378528-391-1.aspxSee the following url for an Instance Security Audit script I wrote. It will tell you whether you have a DENY in your permissions for the database. Hope it helps.http://www.sqlservercentral.com/Forums/Topic1251262-146-1.aspx?Update=1Wed, 31 Oct 2012 14:22:19 GMTvikingDBARE: How to give a user ONLY permission to a view, and nothing else in the databasehttp://www.sqlservercentral.com/Forums/Topic1378528-391-1.aspxRead through this: http://msdn.microsoft.com/en-us/library/ms176097.aspx. I think example H is what you are looking for.Wed, 31 Oct 2012 11:36:01 GMTSQLCerealRE: How to give a user ONLY permission to a view, and nothing else in the databasehttp://www.sqlservercentral.com/Forums/Topic1378528-391-1.aspxHow can I investigate if I have Deny permissions set somewhere ?Tue, 30 Oct 2012 19:55:03 GMTkolnRE: How to give a user ONLY permission to a view, and nothing else in the databasehttp://www.sqlservercentral.com/Forums/Topic1378528-391-1.aspxWorks fine here. You must have a DENY permission set somewhere.[code="sql"]CREATE SCHEMA [Dave]GOCREATE USER [Joe] WITHOUT LOGINGOCREATE TABLE [Dave].[Test1] (Col1 INT, Col2 INT, Col3 INT)GOINSERT INTO Dave.Test1VALUES (1,1,1),(2,2,3),(3,2,4)GOCREATE VIEW dbo.[Test1] ASSELECT Col1, Col2 FROM [Dave].[Test1]GOGRANT SELECT ON dbo.[Test1] TO JoeEXECUTE AS USER = 'Joe'SELECT * FROM [Dave].[Test1]--Msg 229, Level 14, State 5, Line 1--The SELECT permission was denied on the object 'Test1', database 'ABC', schema 'Dave'.SELECT * FROM dbo.[Test1]--Col1 Col2--1 1--2 2--3 2[/code]Mon, 29 Oct 2012 22:02:30 GMTfoxxoHow to give a user ONLY permission to a view, and nothing else in the databasehttp://www.sqlservercentral.com/Forums/Topic1378528-391-1.aspxI need to give user Joe select permissions to a view. The view has columns from two tables from the same database (ABC). Joe should only see the columns in this view, not any underlying tables. I should mention that the two tables are owned by Dave.I thought by writing: "GRANT SELECT ON View1 TO Joe;"but its not working...I receive the following error;The SELECT permission was denied on the object 'tblReviews', database 'ABC', schema 'Dave'.What else can I do ?Mon, 29 Oct 2012 18:10:22 GMTkoln