Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-05-13 : 01:49:07
|
yossi writes "I have 2 users with public permissions in a given databaseHow can I configure the database to grant access only to one of them at a given time?e.g.If one of the users is connected, db will deny connection from the other if he tries to connect.(but number connections of the same user will be unlimited -with the same user it will be possible to make more then one connection) Thanks." |
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-05-13 : 05:27:33
|
USE masterEXEC sp_dboption 'mydatabase', single user', 'TRUE'When true, only one user at a time can access the database. |
|
|
|
|
|