February 4, 2010 at 11:57 am
I try to add db_ddladmin on to a database to a group account on SQL server 2005.
I used both SQL Server Management studio and also tried script
USE [dbname]
GO
EXEC sp_addrolemember N'db_ddladmin', N'Domain\Group-DBAS-Account'
GO
But after refreshing, when I go to management studio and check again, the db_ddladmin is still not checked.
Could you please suggest if I am missing something.
M&M
February 4, 2010 at 12:40 pm
What message do u get in SSMS once you run tht t-sql statement?
Manu
February 4, 2010 at 12:48 pm
Command(s) completed successfully. 🙂
M&M
February 4, 2010 at 12:55 pm
Run 'sp_helpuser' under SSMS and see if that windows group actually got that role assignment or not.
MJ
February 4, 2010 at 1:01 pm
When I run sp_helpuser 'db_ddladmin' under this database in SSMS I can see the group account as a member of this role.
But when I go to SSMS and then server->Security->Login and double click on user account and go to
user mapping, I don't see role 'db_ddladmin' checked for this database
M&M
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply