Want to give a user Create View Permissions

• Mike Carey-155963

  Newbie

  Points: 3

  More actions

  April 4, 2005 at 8:04 am

  #102465

  I assigned a user Public, DB_DATAREADER, and DB_DENYDATAWRITER because I want him to view tables, but not write to any tables. Now he wants to be able to create views. How would I only add Create View rights for this user? Add him to the DB_DDladmin role?

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  April 4, 2005 at 8:31 am

  #550345

  You can use this:

  GRANT CREATE VIEW TO login_name

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/