Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. sql server 2008 security

sql server 2008 security

Scheduled Pinned Locked Moved Database
databasesql-serversysadminsecurity
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Member 3622752
    wrote on last edited by
    #1

    we are using sql server 2008 in desktop application but client machine my database show i want database not show and secure my database please tell me what can i do. thanks badal

    M J 2 Replies Last reply
    0
    • M Member 3622752

      we are using sql server 2008 in desktop application but client machine my database show i want database not show and secure my database please tell me what can i do. thanks badal

      M Offline
      M Offline
      Mycroft Holmes
      wrote on last edited by
      #2

      You can't "hide" your database, you need to apply authentication and authorisation to your database. This will limit what the user can see and do.

      Never underestimate the power of human stupidity RAH

      1 Reply Last reply
      0
      • M Member 3622752

        we are using sql server 2008 in desktop application but client machine my database show i want database not show and secure my database please tell me what can i do. thanks badal

        J Offline
        J Offline
        jschell
        wrote on last edited by
        #3

        Best as I can tell from your question you are asking for something that is impossible. SQL Server normally installs as an application. Thus it is ALWAYS visible on the client machine. Now you could re-architect your application to use the embedded version of SQL Server (I think.) Then it would appear that only your application existed. I suspect this would require a bit of work. There are limitations to that approach. Note as well that this has nothing to do with security. Security means something completely different.

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups