I need to restrict user which was achieved by grant and deny permissions using TSQL in sql server 2008 R2 successfully.
Now i need to update database,For know ,I am using backup/restore for updation of database.
But when ever i did it ,User grant/Deny were needed to assign .
Is their any thing that i used to grant/deny permission and no need to assign then on every restore/backup ???
Kindly let me know
i think you are refering here orphan login fix . right ?
IF you are using same copy of database again and again, then restore the backup , do the login fix and then take the backup and use it everytime.
if you are using different and latest backup copy then you have to do the login fix everytime.
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)