Clave de usuario manager

[luz18]

hola a todos, tengo una consulta que no he podido solventar,

Olvide la clave del usuario manager y mas nadie la tiene por lo que debo cambiarla pero no puedo por el aplicativo, si alguien sabe de algun query que me permita por sql cambiarla se lo agradeceria, un compañero me dio uno pero me da el siguiente error Msg 208, Level 16, State 1, Line 2 Invalid object name ‘OUSR’

[bfierro]

Hola, no probaste generar otra desde otro usuario con Licencia Profesional??

slds

BF

[luz18]

Muchas gracias lo voy a intentar

[Daniel_Torrez]

khe, como puede ser eso posible jajaja, dame 1 min deja ver si la consigo, un companero del trabajo tiene un query parecido.

[Daniel_Torrez]

IF EXISTS (SELECT USERID FROM OUSR WHERE USERID != 1 AND USER_CODE = 'manager')
BEGIN
	DELETE FROM OUSR WHERE USER_CODE = 'manager'
END 

IF NOT EXISTS (SELECT USERID FROM OUSR WHERE USERID = 1)
BEGIN
	Update [dbo].[OUSR] set USERID = 1, INTERNAL_K = 1  where userid in (select top 1 userid from [dbo].[OUSR])
END

UPDATE [dbo].[OUSR]	SET USER_CODE = 'manager' WHERE USERID = 1

-- Generic Manager Query for 9.0 and higher
--update OUSR set password = 'C3D43548E2D0D0E09BED6C47F69C6ADBE4BF9AB1', groups = '0', superuser = 'Y', Locked = 'N' where user_code = 'manager'
--update OUSR set password = 'E362C4E2529C756FE51645701C5D10EF15928E6F', groups = '0', superuser = 'Y', Locked = 'N' where user_code = 'manager'
update OUSR set password = 'E362C4E2529C756FE51645701C5D10EF15928E6F', groups = '0', superuser = 'Y', Locked = 'N' , STData='' where user_code = 'manager'


-- run this update so that you don't get the Create Password form when logging on 
UPDATE OUSR SET OneLogPwd = 'N' WHERE USER_CODE='manager'

IF EXISTS (SELECT tc.[name] FROM SysColumns tc INNER JOIN SysObjects tso ON tc.id = tso.id WHERE tso.[name] = 'OUSR' AND tc.[name] = 'PwdNeverEx')
Begin
	exec('UPDATE OUSR SET PwdNeverEx = ''Y'' WHERE USER_CODE=''manager''')
End

-- Reset Authorization 
-- get ALLOWENCES’s character length of current bo version
Declare @loopCount int 
SET @loopCount = (
SELECT Top 1  len(cast(ALLOWENCES as varchar(MAX))) as countOfChars 
from dbo.OUSR
order by countOfChars desc)
-- encode full authorization
DECLARE @userid int 
SET @userid= '1'; 
IF EXISTS (SELECT tc.[name] FROM SysColumns tc INNER JOIN SysObjects tso ON tc.id = tso.id 
        WHERE tso.[name] = 'OUSR' AND tc.[name] = 'ALLOWENCES') 
BEGIN 
DECLARE @auth nvarchar(max) 
SET @auth = '';   
        DECLARE @i int
        SET @i = 0 
        WHILE @i < @loopCount BEGIN 
           SET @i = @i + 1; 
           SET @auth = @auth + char(1); 
        END 
  -- grand manager with full authorization
        Update dbo.OUSR 
        SET ALLOWENCES = @auth 
        WHERE USERID = @userid; 

  Update dbo.usr3 
  SET permission='F' 
  WHERE userlink=@userid
END

esto seria para Resetear la Pass de manager, quedaria como al inicio, manager / manager

solo que me advirtio mi companero que despues de que el lo corrio la base le mostraba unos errores, aun que no veo que le peque a otras tablas.

[luz18]

graciaaaas, una si no puedo con otro super usuario lo intentare

[Daniel_Torrez]

te recomiendo sacarle un back a tu base antes de correrlo, por cualquier cosa.

[juliancab]

Se resolvió, yo tengo otra forma?

[Gera_Mendez]

Hola compañero, ¿podrías mencionar esa otra alternativa? Sería muy interesante conocerla.

Saludos.

[luz18]

@Daniel_Torrez

IF EXISTS (SELECT USERID FROM OUSR WHERE USERID != 1 AND USER_CODE = ‘manager’) BEGIN DELETE FROM OUSR WHERE USER_CODE = ‘manager’ END IF NOT EXISTS (SELECT USERID FROM OUSR WHERE USERID = 1) BEGIN Update [dbo].[OUSR] set USERID = 1, INTERNAL_K = 1 where userid in (select top 1 userid from [dbo].[OUSR]) END UPDATE [dbo].[OUSR] SET USER_CODE = ‘manager’ WHERE USERID = 1 – Generic Manager Query for 9.0 and higher --update OUSR set password = ‘C3D43548E2D0D0E09BED6C47F69C6ADBE4BF9AB1’, groups = ‘0’, superuser = ‘Y’, Locked = ‘N’ where user_code = ‘manager’ --update OUSR set password = ‘E362C4E2529C756FE51645701C5D10EF15928E6F’, groups = ‘0’, superuser = ‘Y’, Locked = ‘N’ where user_code = ‘manager’ update OUSR set password = ‘E362C4E2529C756FE51645701C5D10EF15928E6F’, groups = ‘0’, superuser = ‘Y’, Locked = ‘N’ , STData=‘’ where user_code = ‘manager’ – run this update so that you don’t get the Create Password form when logging on UPDATE OUSR SET OneLogPwd = ‘N’ WHERE USER_CODE=‘manager’ IF EXISTS (SELECT tc.[name] FROM SysColumns tc INNER JOIN SysObjects tso ON tc.id = tso.id WHERE tso.[name] = ‘OUSR’ AND tc.[name] = ‘PwdNeverEx’) Begin exec(‘UPDATE OUSR SET PwdNeverEx = ‘‘Y’’ WHERE USER_CODE=’‘manager’‘’) End – Reset Authorization – get ALLOWENCES’s character length of current bo version Declare @loopCount int SET @loopCount = ( SELECT Top 1 len(cast(ALLOWENCES as varchar(MAX))) as countOfChars from dbo.OUSR order by countOfChars desc) – encode full authorization DECLARE @userid int SET @userid= ‘1’; IF EXISTS (SELECT tc.[name] FROM SysColumns tc INNER JOIN SysObjects tso ON tc.id = tso.id WHERE tso.[name] = ‘OUSR’ AND tc.[name] = ‘ALLOWENCES’) BEGIN DECLARE @auth nvarchar(max) SET @auth = ‘’; DECLARE @i int SET @i = 0 WHILE @i < @loopCount BEGIN SET @i = @i + 1; SET @auth = @auth + char(1); END – grand manager with full authorization Update dbo.OUSR SET ALLOWENCES = @auth WHERE USERID = @userid; Update dbo.usr3 SET permission=‘F’ WHERE userlink=@userid END

Hols, funciono maravilloso gracias