This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Setting a database(user) to single user mode?

Amit Paleja
Posts: 7
Eclipse IDE Hibernate Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I want to set a particular user (database) to single user mode so that only one user at a time can access it. This is required so as to import data from another user on the same server after which i wish to revert the user to multi user mode.

I tried to achieve this with the following query but in vain:

This sets the entire database server to single user mode and not the user (database) that I want to (the one that am currently connected to).

Is there a way to achieve this?

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic