BB O L
B B O O L
BB O O L
B B O O L
BB O LLLL

Pick one of the below...................
-take the database offline
-put the database in read only mode
-put the db in single user admin only.
-change the users login password (unless they also access other db with the
same p/w)
-deny permission to those users (unless they also access other db with the
same p/w)
-cast a spell over the database server, rendering it inpenitrable to any
plebs.
- in query anilyzer





__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952




Tanmaya.[Email Address Removed]
ponents.com To: "LazyDBA.com Discussion" <[Email Address Removed]
cc:
30/04/2004 03:04 PM Subject: Several databases







Dear all,
I have several database running on the SQL Server with different types
of users working on different databases.
For some maintenance purposes, I want to stop access to the users to one of
the database.

Can it be possible to stop the access to one particular database while
continuing the other databases.





Tanmaya Kumar Pattajoshi
Sr. Executive-IT
Vishay Components India Pvt. Ltd.
Loni,Pune
Ph: 91-20-26913285-5562/5624

"Champions aren't made in the gyms. Champions are made from
something they have deep inside them - a desire, a dream, a
vision."
"The best proof of love is trust."



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed] information contained in this email and any attached files ("Email")
is strictly private and confidential. This Email should be read by the
intended recipient only. If you are not the intended recipient of this
Email or if you believe this is an unsolicited email, please immediately
notify the sender by replying to this email or contact a representative
from the Aon Group of Companies ("Aon") on +61 2 9253 7000 and promptly
destroy this Email and any copies of this Email.

Only the intended recipient of this Email may use, reproduce, disclose or
distribute the information contained in this Email with Aon's permission.
If you are not the intended recipient, you are strictly prohibited from
using, reproducing, disclosing or distributing the information contained in
this Email.

Aon does not represent, warrant or guarantee that the integrity of this
Email has been maintained or that the communication is free of errors,
virus or interference. Aon advises that this Email should be scanned to
detect viruses. Aon accepts no liability for loss or damage (whether
caused by negligence or not) resulting from the use of this Email.

Unless the sender is expressly providing you with personal advice, any
advice contained in this Email has been prepared without taking into
account your objectives, financial situation or needs. Before acting on any
advice in this Email, you should consider whether that advice is
appropriate for your personal circumstances. If this Email contains
reference to any specific financial product(s), Aon recommends you consider
the relevant product disclosure statement or other disclosure document(s)
before making any decision regarding that product."



MS Sql Server LazyDBA home page