Results 1 to 2 of 2

Thread: Help in writing a script to deny users access to a database.

  1. 11-15-2002, 12:33 PM #1
    Katyan
    Katyan is offline Registered User
    Join Date
    Oct 2002
    Location
    Trinidad
    Posts
    52

    Question Help in writing a script to deny users access to a database.

    I have a database that I want to deny users access to during a specific time of the day e.g. 1:00 AM to 7:AM as I have tables that are updated during this time. Can anyone help me with writing a script/job to deny users access to the database?
    Reply With Quote Reply With Quote
  2. 11-15-2002, 02:34 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can set db option 'dbo use only', but the bad news is set db option doesn't disconnect existing users. Have to find spid of existing connection and kill it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules