Posted by rhaazy on 08/16/07 16:36

As it turns out the db_owner is a more likely canidate for the level
of power I wish to give the user.

So what I need to do is add to my database install script, after I add
the user to the database, i need to grant Database Role Membership
(db_owner) for the database ClientScan for the user CSAdmin

exec sp_addlogin 'CSAdmin', 'pwd'

USE ClientScan
exec sp_adduser 'CSAdmin'

exec sp_addrolemember db_owner, CSAdmin

If there is anything wrong with my syntax please correct it.

[Back to original message]