Re: Passwords getting reset?
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/11/02
- Next message: Sue Hoegemeier: "Re: Using ALTER VIEW only....."
- Previous message: jan: "Passwords getting reset?"
- In reply to: dtaylor: "Passwords getting reset?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Fri, 10 May 2002 16:45:59 -0600
If passwords expire, this sounds like you are referring to
NT accounts (SQL Server logins don't have passwords that
expire). This is controlled on the NTside. For an NT user
account, if you don't want the password to expire, use User
Manager and set the option Password never expires for the
account. You can also turn on security auditing on NT if you
need information when accounts are being changed.
If these are SQL logins, as I said, they don't expire so
that wouldn't make much sense. But SQL login passwords can
be changed using sp_password. On SQL 7, a user can change
their own password and sysadmins can execute this for any
login. You could use profiler to create a trace to capture
the execution of sp_password.
-Sue
On 10 May 2002 14:51:17 -0700,
donna.taylor@selectrontechnologies.com (dtaylor) wrote:
>The question is, we have a SQL Server 7.0 application running on NT.
>We are having problems with the passwords getting reset or expired.
>The SQL Server is set up to use SQL Authentication.
>We don't know if it's some process or someone or what is causing this
>to happen. We've never encountered this before.
>We were wondering, if we could "trace" when this happens? We don't
>have a "DBA" just application programmers and this is puzzling us. We
>have many installations and have never ran across this before. Is
>there a stored proc that we can add some kind of trace statement that
>would be responsible for changing passwords?
>It's not a problem with the "grant" of the object because if we simply
>reset the password for the user trying to use the application, it
>solves the access problem.
>Thanx!
- Next message: Sue Hoegemeier: "Re: Using ALTER VIEW only....."
- Previous message: jan: "Passwords getting reset?"
- In reply to: dtaylor: "Passwords getting reset?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
