Post reply

how to secure the database

  • June 13, 2010 at 7:01 am

    #139374

    hi,

    my problem is that if database is created by administrator in sql sever 2005 but he wants that nobody could access that particular database not whole sql server.......................

  • June 13, 2010 at 7:40 am

    #1179604

    Could you explain the situation in more detail please? I'm not sure what you're asking.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 13, 2010 at 8:25 am

    #1179605

    If you literally mean "nobody" than the only way I can think of is "DROP DATABASE".

    Other than that: AFAIK at least all persons with admin permission on that particular server and people assigned to the SQL Server sysadmin role will be able to access this database.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 13, 2010 at 11:53 am

    #1179625

    Lutz is correct. Other administrators will have access, and I'm not sure why they shouldn't have access. What happens if the guy that created it quits?

    If you do not assign any rights to other users, they won't be able to access it.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply