Skip to main content

Posts

Showing posts from November, 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.

User deletion problem in sql database- SQL Troubleshooting

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.