Sql Server Help - Urgent

[Bairagi From Bapatla]

user logins(SQL logins and windows logins) disable and enable cheyadaniki script kavali evari daggara ayina unte please provide cheyandi....

 

 

[tiger_sathi]

help

[Suhaas]

To disable ‘user1’ login:
ALTER LOGIN user1 DISABLE
GO

To enable ‘user1’ login:
ALTER LOGIN user1 ENABLE
GO

[Bairagi From Bapatla]

To disable ‘user1’ login:
ALTER LOGIN user1 DISABLE
GO

To enable ‘user1’ login:
ALTER LOGIN user1 ENABLE
GO

individual login ki kadu baa... Anni logins okesari enable or disable cheydaniki script kavali....

[SwamyRaRa]

Help

[Bukka_Rowdy]

Put it in restriced user mode..

[Bukka_Rowdy]

ALTER DATABASE database-name SET RESTRICTED_USER

[Bairagi From Bapatla]

ALTER DATABASE database-name SET RESTRICTED_USER

ala cheyalenu baa... for example oka 50logins unnai anuko... andhulo 30logins disble cheyali for production release and once release ayyaka aa 30logins enable cheyali...

[SQLbie]

help

[Suhaas]

individual login ki kadu baa... Anni logins okesari enable or disable cheydaniki script kavali....

 

Danne oka cursor lo pettu

 

 

 

Go
DECLARE @DB_USER VARCHAR(MAX)
DECLARE @strSQL VARCHAR(MAX)
DECLARE MY_CURSOR CURSOR
  LOCAL STATIC READ_ONLY FORWARD_ONLY
FOR
SELECT NAME FROM SYS.SERVER_PRINCIPALS WHERE TYPE_DESC = 'SQL_USER'

OPEN MY_CURSOR
FETCH NEXT FROM MY_CURSOR INTO @DB_USER
WHILE @@FETCH_STATUS = 0
BEGIN
   
SET @strSQL  = 'ALTER LOGIN '+ @DB_USER + ' ENABLE'
EXEC(@strSQL)
PRINT @DB_USER + ' ENABLED'
    FETCH NEXT FROM MY_CURSOR INTO @DB_USER
END
CLOSE MY_CURSOR
DEALLOCATE MY_CURSOR
 

[deleted1]

Help

[Bairagi From Bapatla]

LTT

[duvva_abbulu]

Go

DECLARE @DB_USER VARCHAR(MAX)

DECLARE @strSQL VARCHAR(MAX)

DECLARE MY_CURSOR CURSOR

  LOCAL STATIC READ_ONLY FORWARD_ONLY

FOR

SELECT name 

FROM sys.server_principals 

WHERE TYPE IN ('U', 'S', 'G')

and name not like '%##%'

ORDER BY name, type_desc

 

OPEN MY_CURSOR

FETCH NEXT FROM MY_CURSOR INTO @DB_USER

WHILE @@FETCH_STATUS = 0

BEGIN

   

SET @strSQL  = 'ALTER LOGIN '+ @DB_USER + ' ENABLE'

print (@strSQL)

--PRINT @DB_USER + ' ENABLED'

    FETCH NEXT FROM MY_CURSOR INTO @DB_USER

END

CLOSE MY_CURSOR

DEALLOCATE MY_CURSOR

 

 

this will give u the alter statements. direct execute cheskovali anukunte replace print (@strSQL) with exec (@strSQL).

 

where condition neku kavalsina condition ichuko.. adi kuda cheppalsina avasram ledu anukunta

[Newlifes]

ltt

[Suhaas]

 

Go

DECLARE @DB_USER VARCHAR(MAX)

DECLARE @strSQL VARCHAR(MAX)

DECLARE MY_CURSOR CURSOR

  LOCAL STATIC READ_ONLY FORWARD_ONLY

FOR

SELECT name 

FROM sys.server_principals 

WHERE TYPE IN ('U', 'S', 'G')

and name not like '%##%'

ORDER BY name, type_desc

 

OPEN MY_CURSOR

FETCH NEXT FROM MY_CURSOR INTO @DB_USER

WHILE @@FETCH_STATUS = 0

BEGIN

   

SET @strSQL  = 'ALTER LOGIN '+ @DB_USER + ' ENABLE'

print (@strSQL)

--PRINT @DB_USER + ' ENABLED'

    FETCH NEXT FROM MY_CURSOR INTO @DB_USER

END

CLOSE MY_CURSOR

DEALLOCATE MY_CURSOR

 

 

this will give u the alter statements. direct execute cheskovali anukunte replace print (@strSQL) with exec (@strSQL).

 

where condition neku kavalsina condition ichuko.. adi kuda cheppalsina avasram ledu anukunta

 

 

 

GP