SQL statement change db_owner value for a specific user

Question

I need to change db_owner field to true for the user BUILTIN\Users.

what is the SQL i need to do in sql server 2008 ?

thanks

Answer 1

Try this:

EXEC sp_addrolemember 'db_owner', 'BUILTIN\Users'

In general the format for a windows login should be:

EXEC sp_addrolemember 'db_owner', '<computer>\<user>'

MSDN link