Database Property

Last post 09-26-2008 10:12 AM by ashish.johri. 3 replies.
Page 1 of 1 (4 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 09-24-2008 10:15 AM

    Database Property

    Reply Contact

    I want the properties of my database to be unavailable to any user. Could you please tell me how to do this setup?

    -Ashish

  • 09-24-2008 4:59 PM In reply to

    Re: Database Property

    Reply Contact

     You have to remove any sa privileges  from the user.

     

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    When the power of love overcomes the love of the power, the world will know peace.

    J. Hendrix


    All postings are provided “AS IS” with no warranties for accuracy.

  • 09-25-2008 12:31 PM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,515
    • Microsoft MVP
      Moderator

    Re: Database Property

    Reply Contact

    What version of SQL you are using?
    How many users will have SA privileges on this server?

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.

  • 09-26-2008 10:12 AM In reply to

    Re: Database Property

    Reply Contact

     Thanks for response Satya,

    That is sql server 2005. Around 30000 users log in at one time.
    -Ashish
Page 1 of 1 (4 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.