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.
No comments:
Post a Comment