Role with owner privilege?

up vote 2 down vote favorite

How can i create new role and provide owner privilege for specific database in SQL Server?

asked Jan 13 '10 at 21:38

sanjeev40084

	This will be migrated to ServerFault, please look there for good answers. – Lance Roberts Jan 13 '10 at 21:42
	I'd consider this to be an SO question if the OP wants to be able to script permissions. – David Hall Jan 13 '10 at 21:48

feedback

migrated from stackoverflow.com Jan 13 '10 at 22:27

This question came from our site for professional and enthusiast programmers.

1 Answer

active oldest votes

up vote 3 down vote

CREATE ROLE NewRole
EXEC sp_addrolemember 'db_owner', 'NewRole'

answered Jan 13 '10 at 21:51

feedback