{"id":558,"date":"2008-08-06T22:27:38","date_gmt":"2008-08-06T21:27:38","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=558"},"modified":"2008-08-06T22:27:38","modified_gmt":"2008-08-06T21:27:38","slug":"alter-user-with-login-arva-adatbazisfelhasznalok-orokbefogadasara","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2008\/08\/06\/alter-user-with-login-arva-adatbazisfelhasznalok-orokbefogadasara\/","title":{"rendered":"ALTER USER WITH LOGIN \u00e1rva adatb\u00e1zisfelhaszn\u00e1l\u00f3k \u00f6r\u00f6kbefogad\u00e1s\u00e1ra"},"content":{"rendered":"<p>Apr\u00f3, de hasznos tudnival\u00f3.<br \/>\nMent\u00e9sb\u0151l vissza\u00e1ll\u00edtott adatb\u00e1zisok klasszikus probl\u00e9m\u00e1ja, hogy hi\u00e1ba van a vissza\u00e1ll\u00edtott adatb\u00e1zisban J\u00f3zsi nev\u0171 felhaszn\u00e1l\u00f3, \u00e9s hi\u00e1ba van a szerverszint\u0171 loginok k\u00f6z\u00f6tt J\u00f3zsi, a kett\u0151 nem akar egym\u00e1sra tal\u00e1lni.<br \/>\nR\u00e9gebben az sp_change_users_login-t haszn\u00e1ltuk a p\u00e1rkeres\u00e9sre.<\/p>\n<p>SQL 2005-t\u0151l m\u0171k\u00f6dik az ALTER USER WITH LOGIN is, ez r\u00e1ad\u00e1sul az el\u0151bbivel ellent\u00e9tben NEM csak standard loginokra m\u0171k\u00f6dik.<\/p>\n<p>ALTER USER user_name WITH LOGIN = login_name<\/p>\n<p>Az sp_change_users_login viszont egyszerre sok felhaszn\u00e1l\u00f3t is tud p\u00e1ros\u00edtani, \u00edgy nem \u00e9rdemes teljesen elfelejteni.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Apr\u00f3, de hasznos tudnival\u00f3. Ment\u00e9sb\u0151l vissza\u00e1ll\u00edtott adatb\u00e1zisok klasszikus probl\u00e9m\u00e1ja, hogy hi\u00e1ba van a vissza\u00e1ll\u00edtott adatb\u00e1zisban J\u00f3zsi nev\u0171 felhaszn\u00e1l\u00f3, \u00e9s hi\u00e1ba van a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30,21,58],"tags":[],"class_list":["post-558","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=558"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/558\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}