Software Applications Programming Errors and solutions.

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.

If you want to delete any user from database security but you are not able to delete that user due to schema then you can change schema authorization to dbo. To do that you can try following command in sql query analyzer. use databasename ALTER AUTHORIZATION ON SCHEMA::YourSchemaName TO dbo; I hope this post will help you.