Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: lock a user password

    We have a generic account needs to access the database overnight doing some batch jobs. One day some stupid guy decided to reset its password and all things went wrong

    The question is if it is at all possible to lock the password of this account, so that nobody can change it (apart from ppl with sso_role).

    version is Adaptive Server Enterprise/12.0.0.3.

    Thanks in advance

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4

    Talking

    Did that 'stupid guy' have the sso_role? If so, threaten to take it away from him if he resets the password again .
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Jun 2004
    Posts
    1

    Thumbs up lock userlogin

    use sp_locklogin command...

  4. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Quote Originally Posted by kevlar
    use sp_locklogin command...
    That way, no-one can use it, not even the batch-job which uses it regularly.

    Yet, of you unlock the login before you use it and re-lock it when you're done, it can work. But I don't think you want that. You'd have to have a login/user with sso_role to do such a thing. And that user will also be able to change the password for the batch-job-login, so it won't do much good.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

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