Home Forums SQL Server 2005 SQL Server 2005 Security How to deny restore database in sql server to SA? RE: How to deny restore database in sql server to SA?

  • August 29, 2013 at 7:17 am

    #1645971

    das.saroj09 (8/29/2013)

    it can be a great help for this kind of situation and can it be as permanent for the server. where will change or it can only for the persion who changed it ?

    It is not a permanent thing as it can be reset to any color (or no color at all) at any time, including things that cause SSMS to reset to default settings.

    As far as I know, all OPTIONS for SQL Server are user sensitive only and do not translate to all people touching the server.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.