Can someone provide me with instructions or a link on how to add a user to a database using SQL Server Management studio Express?
I also would like to know how you set the db_owner permission to the user?
My host has an sql express database and I would like to use the same connection string on my local machine, but need to set up the username/pw on the database locally.
Thanks
go to the security tab of the management express
in the object explorer. double click logins to expand
right click and then add new user
from there you can grant the user access to database.
you can also open the database to add new user to it when you
already created a login in the security tab
No comments:
Post a Comment