Virtual Business Card


A Jack of all trades is a master of integration, as such an individual who knows enough from many learned trades and skills to be able to bring their disciplines together in a practical manner, and is not a specialist but can be an expert in many fields. Such a person is known as a polymath or a renaissance man; a typical example is someone like Leonardo da Vinci.

Tuesday, September 21, 2010

Remap user permissions to objects in the database

There's a time where you need to restore a prod database over a test database. Then all permissions in the stored procedures were gone. To fix this execute the following command:

EXEC sp_change_users_login 'Auto_Fix', ''

This will remap the database users login to the right objects.

**This must be done to all database user

No comments:

Post a Comment