{"id":992,"date":"2010-11-16T05:41:43","date_gmt":"2010-11-16T05:41:43","guid":{"rendered":"http:\/\/pchero21.com\/?p=992"},"modified":"2010-11-16T05:41:43","modified_gmt":"2010-11-16T05:41:43","slug":"sybase-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%b6%94%ea%b0%80%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/pchero21.com\/?p=992","title":{"rendered":"SYBASE \uc0ac\uc6a9\uc790 \ucd94\uac00\ud558\uae30"},"content":{"rendered":"

 SYBASE \uc5d0\uc11c\uc758 \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc29\ubc95<\/p>\n

sp_addlogin ‘\uc544\uc774\ub514’,’\ud328\uc2a4\uc6cc\ub4dc’<\/p>\n

 <\/p>\n

 <\/p>\n

 sp_adduser ‘\uc544\uc774\ub514’<\/p>\n

 sp_dropuser ‘\uc544\uc774\ub514’<\/p>\n

 <\/p>\n

 <\/p>\n

 % isql -Usa -Ppassword -Sservername
\n 1> use master
\n 2> go
\n 1> sp_addlogin scott, tiger, test
\n 2> go
\n 1> use test
\n 2> go
\n 1> sp_adduser scott
\n 2> go<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

exec  sp_addlogin  ‘homeusr’, ‘password’, @defdb=’ebaihome’, @auth_mech = ‘ASE’
\n exec sp_locklogin  ‘homeusr’, ‘unlock’<\/p>\n

 go<\/p>\n

 <\/p>\n

use ebaihome
\n go<\/p>\n

exec sp_adduser ‘homeusr’ ,’homeusr’ ,’public’
\n go  <\/p>\n

——————————————————————————————————————————————————
\ucd9c\ucc98 : http:\/\/benelog.springnote.com\/pages\/349014<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

 SYBASE \uc5d0\uc11c\uc758 \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc29\ubc95 sp_addlogin ‘\uc544\uc774\ub514’,’\ud328\uc2a4\uc6cc\ub4dc’      sp_adduser ‘\uc544\uc774\ub514’  sp_dropuser ‘\uc544\uc774\ub514’      % isql -Usa -Ppassword -Sservername 1> use master 2> go 1> sp_addlogin scott, tiger, test 2> go 1> use test 2> go 1> sp_adduser scott … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[142,369],"_links":{"self":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/992"}],"collection":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=992"}],"version-history":[{"count":0,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/992\/revisions"}],"wp:attachment":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=992"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}