November 28, 2013

Rights assignment to sql database for users

If you have lot of databases in sql and want to add any user to all database then you do not need to add user in each database. You can add user directly from security menu in sql which is located outside of databases.

security menu exists in all individual database and outside of database so if you add user from outside then that user get automatically added to all database. You can assign right using server mapping properties.

No comments:

Post a Comment