SQLServerCentral / SQL Server 2008 / Security (SS2K8) / assigning a special user some special privileges / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 00:53:56 GMT20RE: assigning a special user some special privilegeshttp://www.sqlservercentral.com/Forums/Topic1403429-1526-1.aspxCreate view requires CREATE VIEW permission in the database and ALTER permission on the schema in which the view is being created.Also db_datareader will do for reading from all tables.Mon, 07 Jan 2013 01:31:23 GMTanthony.greenassigning a special user some special privilegeshttp://www.sqlservercentral.com/Forums/Topic1403429-1526-1.aspxHello all,I need some help assigning a special user some special privileges (Role).I need to give the user reading rights on all tables.I need to give the user creating right if views.I don't want to allow him ddl_admin since then he will be able to Drop & Truncate tables.I think I need to create flexible database role but I don't know how to.Thanks in advance,David.Sun, 06 Jan 2013 23:55:19 GMTb768647