Updating a User Password in all databases in SQL Server 2008

Question

Hi All,

Is there are way to Update a User password in all database of SQL Server 2008 Instance?

DECLARE @user varchar(1000)

SELECT @createwebuser = 
'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'') 

BEGIN USE ? 

IF  EXISTS (UPDATE sys.database_principals set password =''sasa'' WHERE name = N''myuser'')

END'

EXEC sp_msforeachdb @createwebuser

This script is throwing up error because there is no column with name password in the sys.database_principals. Any ideas where the password of a user will store and how we can update that?

Answer 1

0

Users don't have passwords, logins do. So you need only change the password once for the instance, and all databases within the instance will be 'affected'.

And... the error isn't just because the column isn't there - it's also because that's not how to change a password. Try ALTER LOGIN instead.

answered Jan 28 '10 at 10:23 PM

Rob Farley
5.7k ● 13 ● 17 ● 19

(comments are locked)

Updating a User Password in all databases in SQL Server 2008

Follow this question

Related Questions