½Ã½ºÅÛ°ü¸®ÀÚÀÇ ½°ÅÍ Ä¿ÇǴнº Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
 FAQFAQ   °Ë»ö°Ë»ö   ¸â¹ö¸®½ºÆ®¸â¹ö¸®½ºÆ®   »ç¿ëÀÚ ±×·ì»ç¿ëÀÚ ±×·ì   »ç¿ëÀÚ µî·ÏÇϱâ»ç¿ëÀÚ µî·ÏÇϱâ 
 °³ÀÎ Á¤º¸°³ÀÎ Á¤º¸   ºñ°ø°³ ¸Þ½ÃÁö¸¦ È®ÀÎÇÏ·Á¸é ·Î±×ÀÎÇϽʽÿÀºñ°ø°³ ¸Þ½ÃÁö¸¦ È®ÀÎÇÏ·Á¸é ·Î±×ÀÎÇϽʽÿÀ   ·Î±×Àηα×ÀΠ

°¡ÀÔ¾øÀÌ ´©±¸³ª ±ÛÀ» ¾µ ¼ö ÀÖ½À´Ï´Ù. °øÁö»çÇ׿¡ ´ëÇÑ ´ñ±Û±îÁöµµ..




BBS >> ¼³Ä¡, ¿î¿µ Q&A | ³×Æ®¿÷, º¸¾È Q&A | ÀÏ¹Ý Q&A || Á¤º¸¸¶´ç | AWS || ÀÚÀ¯°Ô½ÃÆÇ | ±¸Àα¸Á÷ || °øÁö»çÇ× | ÀÇ°ßÁ¦½Ã
sql ¹Ùº¸ÀÔ´Ï´Ù....

 
±Û ¾²±â   ´äº¯ ´Þ±â    Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ °Ô½ÃÆÇ À妽º -> ½Ã½ºÅÛ ¼³Ä¡ ¹× ¿î¿µ
ÀÌÀü ÁÖÁ¦ º¸±â :: ´ÙÀ½ ÁÖÁ¦ º¸±â  
±Û¾´ÀÌ ¸Þ½ÃÁö
±â°­
¼Õ´Ô





¿Ã¸®±â¿Ã·ÁÁü: 2011.8.23 È­, 4:54 pm    ÁÖÁ¦: sql ¹Ùº¸ÀÔ´Ï´Ù.... Àοë°ú ÇÔ²² ´äº¯ ±Û ÆíÁý/»èÁ¦

create procedure sp_password > @old sysname = NULL, -- the old (current) password > @new sysname, -- the new password > @loginame sysname = NULL -- user to change password on > as > -- SETUP RUNTIME OPTIONS / DECLARE VARIABLES -- > set nocount on > declare @self int > select @self = CASE WHEN @loginame is null THEN 1 ELSE 2 END > > -- RESOLVE LOGIN NAME > if @loginame is null > select @loginame = suser_sname() > > -- CHECK PERMISSIONS (SecurityAdmin per Richard Waymire) -- > IF (not is_srvrolemember('securityadmin') = 1) > AND not @self = 1 > begin > dbcc auditevent (107, @self, 0, @loginame, NULL, NULL, NULL) > raiserror(15210,-1,-1) > return (1) > end > ELSE > begin > dbcc auditevent (107, @self, 1, @loginame, NULL, NULL, NULL) > end > > -- DISALLOW USER TRANSACTION -- > set implicit_transactions off > IF (@@trancount > 0) > begin > raiserror(15002,-1,-1,'sp_password') > return (1) > end > > -- RESOLVE LOGIN NAME (disallows nt names) > if not exists (select * from master.dbo.syslogins where > loginname = @loginame and isntname = 0) > begin > raiserror(15007,-1,-1,@loginame) > return (1) > end > > -- IF non-SYSADMIN ATTEMPTING CHANGE TO SYSADMIN, REQUIRE PASSWORD (218078) -- > if (@self <> 1 AND is_srvrolemember('sysadmin') = 0 AND exists > (SELECT * FROM master.dbo.syslogins WHERE loginname = @loginame and > isntname = 0 > AND sysadmin = 1) ) > SELECT @self = 1 > > -- CHECK OLD PASSWORD IF NEEDED -- > if (@self = 1 or @old is not null) > if not exists (select * from master.dbo.sysxlogins > where srvid IS NULL and > name = @loginame and > ( (@old is null and password is null) or > (pwdcompare(@old, password, (CASE WHEN xstatus&2048 = 2048 THEN 1 ELSE 0 END)) > = 1) ) ) > begin > raiserror(15211,-1,-1) > return (1) > end > > -- CHANGE THE PASSWORD -- > update master.dbo.sysxlogins > set password = convert(varbinary(256), pwdencrypt(@new)), xdate2 = getdate(), xstatus = xstatus & > (~2048) > where name = @loginame and srvid IS NULL > > -- UPDATE PROTECTION TIMESTAMP FOR MASTER DB, TO INDICATE SYSLOGINS CHANGE -- > exec('use master grant all to null') > > -- FINALIZATION: RETURN SUCCESS/FAILURE -- > if @@error <> 0 > return (1) > raiserror(15478,-1,-1) > return (0) -- sp_password > >

´Ù¸¥°÷¿¡¼­ sp_passwod°ü·Ã ã´Ù°¡ ãÀº ÇÁ·Î½ÃÀú»ý¼º¹®Àε¥

Äõ¸®½ÇÇà±â·Î ÀÔ·ÂÇÏ´Ï±î ¹®±¸¿¡ ¿À·ùÀÖ´Ù°í ³ª¿À³×¿ä ¤Ð.¤Ð

Ʋ¸°ºÎºÐ ¼öÁ¤Á» ºÎŹµå·Áµµ µÉ±î¿ä~

»ý¼º¹® Ãâó
http://www.devpia.com/MAEUL/Contents/Detail.aspx?BoardID=38&MAEULNO=16&no=61855&ref=61855
À§·Î
ÀÌÀü ±Û Ç¥½Ã:   
±Û ¾²±â   ´äº¯ ´Þ±â    Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ °Ô½ÃÆÇ À妽º -> ½Ã½ºÅÛ ¼³Ä¡ ¹× ¿î¿µ ½Ã°£´ë: GMT + 9 ½Ã°£(Çѱ¹)
ÆäÀÌÁö 1 Áß 1

 
°Ç³Ê¶Ù±â:  
»õ·Î¿î ÁÖÁ¦¸¦ ¿Ã¸± ¼ö ¾ø½À´Ï´Ù
´ä±ÛÀ» ¿Ã¸± ¼ö ¾ø½À´Ï´Ù
ÁÖÁ¦¸¦ ¼öÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù
¿Ã¸° ±ÛÀ» »èÁ¦ÇÒ ¼ö ¾ø½À´Ï´Ù
ÅõÇ¥¸¦ ÇÒ ¼ö ¾ø½À´Ï´Ù


Powered by phpBB © 2001, 2005 phpBB Group