Home Forums SQL Server 2008 Security (SS2K8) Accidentally deleted all existing privilges for a domain account - Help RE: Accidentally deleted all existing privilges for a domain account - Help

  • The master will have your login premissions, but if you want to get back your DB premissions you will need to have the user databases. Now maybe you have orphaned users in your user DBs, so I would restore master first and then use sp_change_users_login sproc to see if you can take care of the orphaned users. If not, then you will need to restore at least the Primary FG on each user database.

    http://technet.microsoft.com/en-us/library/ms177425.aspx



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]