{"id":43376,"date":"2024-06-18T12:14:26","date_gmt":"2024-06-18T12:14:26","guid":{"rendered":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/?post_type=ht_kb&#038;p=43376"},"modified":"2024-06-18T13:11:31","modified_gmt":"2024-06-18T13:11:31","slug":"jakie-uprawnienia-potrzebuje-login-sql-aby-umozliwic-komunikacje-z-comarch-erp-menadzer-kluczy","status":"publish","type":"ht_kb","link":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/dokumentacja\/jakie-uprawnienia-potrzebuje-login-sql-aby-umozliwic-komunikacje-z-comarch-erp-menadzer-kluczy\/","title":{"rendered":"Jakie uprawnienia potrzebuje login SQL, aby umo\u017cliwi\u0107 komunikacj\u0119 z Comarch ERP Menad\u017cer Kluczy?"},"content":{"rendered":"<p style=\"text-align: justify;\">Login wymaga dost\u0119pu do rozszerzonych procedur sk\u0142adowanych b\u0119d\u0105cych w bazie master o nazwach zaczynaj\u0105cych si\u0119 od xp_HASP. Instalacja Comarch ERP Menad\u017cer Kluczy nadaje uprawnienia roli public do tych procedur.<\/p>\n<p style=\"text-align: justify;\">Jak utworzy\u0107 login SQL z takimi uprawnieniami?<\/p>\n<p style=\"text-align: justify;\">Na serwerze SQL nale\u017cy w Microsoft SQL Server Management Studio na ga\u0142\u0119zi Security \/ Logins doda\u0107 nowy login z w\u0142asn\u0105 nazw\u0105 i has\u0142em.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-43377 aligncenter\" src=\"https:\/\/pomoc.comarch.pl\/optima\/pl\/2025\/wp-content\/uploads\/2024\/06\/login1.png\" alt=\"\" width=\"800\" height=\"660\" srcset=\"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login1.png 800w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login1-300x248.png 300w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login1-768x634.png 768w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login1-50x41.png 50w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login1-600x495.png 600w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login1-320x264.png 320w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\">W menu Server Roles nale\u017cy wybra\u0107 rol\u0119 Public.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-43378\" src=\"https:\/\/pomoc.comarch.pl\/optima\/pl\/2025\/wp-content\/uploads\/2024\/06\/login2.png\" alt=\"\" width=\"800\" height=\"660\" srcset=\"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login2.png 800w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login2-300x248.png 300w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login2-768x634.png 768w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login2-50x41.png 50w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login2-600x495.png 600w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/login2-320x264.png 320w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\">Utworzony login wraz z has\u0142em nale\u017cy poda\u0107 przy pr\u00f3bie po\u0142\u0105czenia z Comarch ERP Menad\u017cer Kluczy.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-43379\" src=\"https:\/\/pomoc.comarch.pl\/optima\/pl\/2025\/wp-content\/uploads\/2024\/06\/polaczenie.png\" alt=\"\" width=\"765\" height=\"370\" srcset=\"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/polaczenie.png 765w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/polaczenie-300x145.png 300w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/polaczenie-50x24.png 50w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/polaczenie-600x290.png 600w, https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-content\/uploads\/2024\/06\/polaczenie-320x155.png 320w\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Login wymaga dost\u0119pu do rozszerzonych procedur sk\u0142adowanych b\u0119d\u0105cych w bazie master o nazwach zaczynaj\u0105cych si\u0119 od xp_HASP. Instalacja Comarch ERP Menad\u017cer Kluczy nadaje uprawnienia roli public do tych procedur. Jak utworzy\u0107 login SQL z takimi uprawnieniami? Na serwerze SQL nale\u017cy w Microsoft SQL Server Management Studio na ga\u0142\u0119zi Security \/ Logins doda\u0107 nowy login z [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_ht_kb_usefulness":0,"_ht_kb_post_views_count":2788,"_ht_kb_article_order":0,"_ht_kb_reading_time":1,"footnotes":""},"ht_kb_category":[388],"ht_kb_tag":[],"class_list":["post-43376","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-licencjonowanie-klucze-hasp"],"_links":{"self":[{"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/ht_kb\/43376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/comments?post=43376"}],"version-history":[{"count":1,"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/ht_kb\/43376\/revisions"}],"predecessor-version":[{"id":43380,"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/ht_kb\/43376\/revisions\/43380"}],"wp:attachment":[{"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/media?parent=43376"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/ht_kb_category?post=43376"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/optima\/pl\/2027\/wp-json\/wp\/v2\/ht_kb_tag?post=43376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}