Stack Overflow
Stack Overflow

Questions tagged [single-user]

An environment paradigm that doesn't involve multiple user identities.

23 questions
0
votes
1 answer

SQL Server database keeps setting SINGLE_USER on in tests

I have 2 docker containers that host their own server. I also have a 3rd docker container that hosts a SQL Server database. Each server accesses this database. My DB docker container is configured as so in the docker-compose.yml: my-db: image:…
Ian Kirkpatrick
  • 1,861
  • 14
  • 33
0
votes
4 answers

Good Single User Open Source Persistant Database that's easy to install and works with Open Office Base?

I'm creating a program for end-users, that's already written using MySQL and some OpenOffice.org Star Basic Macros. I was wondering if there was an open source single user database that would be easy enough for the average Joe to install, (or that…
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
1 answer

Loop through DB list setting DB to single user Mode

I'm trying to create a dynamic SQL statement to set a database into Single-user mode so that later I can do a restore onto it. I've placed an execute SQL task inside a loop where a parameter is used to provide the name of the next database to set…
ErickTreetops
  • 3,189
  • 4
  • 27
  • 37
0
votes
1 answer

Force log out if multiple sign-in's

How do I configure Devise so that if a user signs in from another device (not Devise!) and has failed to log out from that other device such that the user is asked if a forced log out of the OTHER log-in should be done? I assume Devise can detect…
RalphShnelvar
  • 557
  • 1
  • 6
  • 17
0
votes
1 answer

SQL Server - Single User Mode - Persist Which User

Question Is there a way, when putting a database into single user mode, to specify that user (in my case it is the current user), and to ensure that even after that user disconnects, the single session kept reserved for that defined user; i.e. so it…
JohnLBevan
  • 22,735
  • 13
  • 96
  • 178
0
votes
5 answers

How do I go back to multi_user mode

Here is my query: IF EXISTS(%some query%) BEGIN BEGIN TRY ALTER DATABASE [MyDatabase] SET single_user WITH ROLLBACK IMMEDIATE; --do something --throw some exception END TRY BEGIN CATCH --here I…
dmigo
  • 2,849
  • 4
  • 41
  • 62
0
votes
2 answers

Logout issues in a single-user system

I've been asked to build a project management application that could only host one user at a time. I managed to do that by simply creating a status row in my user table which is set to 1 when somebody is logged in. Now, status = 1, nobody else can…
morgi
  • 1,005
  • 3
  • 17
  • 24
0
votes
1 answer

Ruby on Rails - Devise and Active Admin single model HABTM

Im using rails 3.2 and am having trouble using pre-created devise alongside active admin using a single model and an HABTM relation to a Role model. I've followed this tutorial…
Silver
  • 693
  • 1
  • 10
  • 27
1
2