Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: login restriction

    Dear All,

    Is there any way to restrict users from logging into ASE server.
    When i want to take the the shutdown of server ,I kill the users if they are not coming out of sessions but they again log in from new session. Suppose incidently i give the shutdown command, shutdown process will wait unless they logged out or i have to kill them ,Because of that i have to give shutdown with nowait ,which is generally not recommended.
    I want to write a script where once i lock the system, no body is able to access the system.
    Waiting to hear some good views on that.

    Thakns & Regards

  2. #2
    Join Date
    Sep 2003

    Re: login restriction

    Use sp_dboption to enable the single user db option for the database.

Posting Permissions

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