Saturday, July 21, 2012

windows azure user

create login username with password = 'password'; (on master)
create user username for login username; (on database)
exec sp_addrolemember 'db_owner', 'username'

No comments:

Post a Comment