Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: How to access Database in single user mode all time

    Dear All,
    I want my SQL database to be accessed always in a single user mode through my application. How can I do this ?

    Thanks in advance.

    Sushma

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Here's a question to you :

    Are you sure you REALLY want to do this ???

    Single user mode effectively means that one and a max of only one connection can be made to the database. Do realize this before trying anything of this sort out. This also means that once a user has connected to the database, YOU cannot connect to the database even for admin tasks.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    A better option is to restrict the user access thru sql security.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is just idle curiousity, but why on earth would you want such a thing ?!?!

    When I think about the kind of effort I spend getting more users into the same data at the same time, it is hard for me to imagine why someone might deliberately choose to make a database single user. It isn't hard to do, I just can't imagine what reason might provoke you into doing it!

    -PatP

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Think of it as a cruise ship with only one deck chair.

    You could have just bought a canoe.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2004
    Posts
    492
    If you'd like to have the same user which is used to connect to the database specific for this application, you could create a sqluser and use that from the application. You'll have to think about how to handle the password (if any): keep it save and easy to maintain. If it's *one* user for each instance of the application, I guess you'll have to look for connection pooling.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •