{"id":55761,"date":"2019-05-04T15:22:50","date_gmt":"2019-05-04T09:52:50","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=55761"},"modified":"2021-12-04T13:13:00","modified_gmt":"2021-12-04T07:43:00","slug":"sap-hana-authentication-methods","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/","title":{"rendered":"5 SAP HANA Authentication Methods &#8211; Must Know for User Verification"},"content":{"rendered":"<p>After getting a fair idea of <strong>SAP HANA Sidecar<\/strong>, let us explore the different security functions involved in the entire SAP HANA security framework. One such security function used at the initial stages of working with SAP HANA is the user authentication.<\/p>\n<p>So, stay with us as we learn about user authentication and different authentication methods in SAP HANA.<\/p>\n<h3>SAP HANA Authentication<\/h3>\n<p>Any user who has access rights to use SAP HANA database is verified for authenticity before granting access. The authentication process involves the verification of the authentic identity of the user.<\/p>\n<p>In SAP HANA, there are mainly five different authentication methods. We will discuss all the different authentication modes in detail.<\/p>\n<ul>\n<li>User Name\/Password<\/li>\n<li>Kerberos<\/li>\n<li>Security Assertion Markup Language (SAML 2.0)<\/li>\n<li>SAP Logon and Assertion Tickets<\/li>\n<li>X.509<\/li>\n<\/ul>\n<p>Some of these authentication methods play an important role in integrating or incorporating the SSO (Single Sign-On) environments into SAP HANA.<\/p>\n<h3>Authentication Methods in SAP HANA<\/h3>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-methods-availability.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-55793\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-methods-availability.jpg\" alt=\"SAP HANA Authentication methods availability\" width=\"802\" height=\"420\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-methods-availability.jpg 802w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-methods-availability-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-methods-availability-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-methods-availability-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-methods-availability-520x272.jpg 520w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<h4>1. User name\/ Password<\/h4>\n<p>In this method, you have to enter your user name and password to get access into the HANA system. It is the most basic way of authenticating users.<\/p>\n<p>With the help of a stored profile specific to you under the Security Tab (in User Management section) of <strong>SAP HANA Studio<\/strong>, the system will verify the user name and password. You must create the password according to the password policy of the company or the standard password policy.<\/p>\n<p>A password policy decides a password length, complexity, use of special characters, lower and upper case, etc. It is compulsory for the system to have a password policy and thus you cannot deactivate it in HANA user authentication.<\/p>\n<h4>2. Kerberos<\/h4>\n<p>The Kerberos method enables <strong>direct authentication of a HANA user<\/strong> using external authentication methods. The system will map external login to your SAP HANA user profile and external platforms will\u00a0directly authenticate you in SAP HANA.<\/p>\n<p><strong>For example<\/strong>\u00a0&#8211; You can authenticate yourselves via JDBC\/ODBC drivers through a network connection or using SAP Business Object which is a front-end application.<\/p>\n<p>In addition to this, user authentication in SAP HANA XS is also possible for HTTP access. This process uses HANA XS engine and SPENGO mechanism to carry out Kerberos authentication.<\/p>\n<h4>3. SAML 2.0<\/h4>\n<p><strong>SAML i.e. Security Assertion Markup Language<\/strong> authenticates users who request direct access to SAP HANA from ODBC\/JDBC clients. Although, SAML is only for authentication purposes and not for authorization purposes.<\/p>\n<p>In addition to directly authenticating ODBC\/JDBC clients, this method also authenticates users who want to access HANA from HTTP using a HANA XS engine.<\/p>\n<h4>4. SAP Logon tickets and SAP Assertion Tickets<\/h4>\n<p>The two ticket-based methods are native to SAP HANA and are <strong>only for native SAP HANA users<\/strong> as it does not map user information into SAP HANA from external applications. Thus, the logon tickets and assertion tickets method is a direct way of user authentication.<\/p>\n<p>The users requesting access to SAP HANA system are issued user specific tickets using which they get access into the system. It is important that the user tickets gets created in the SAP HANA system.<\/p>\n<h4>5. X.509<\/h4>\n<p>This method is again an indirect way of authenticating users to let them access SAP HANA. The users requesting access into the SAP HANA database from SAP HANA XS system via an HTTP request are assigned user-specific X.509 certificates.<\/p>\n<p>These certificates are created and signed by the trusted certification authority and thus are a legitimate mode of authentication. The user to which a certificate is assigned for authentication must have a <strong>profile stored in SAP HANA <\/strong>for verification.<\/p>\n<p>It is because this method does not map user data from external sources into SAP HANA.<\/p>\n<h3>Summary<\/h3>\n<p>This comes to the end of our explanation of the different authentication methods used in SAP HANA. In the next tutorial, we will be discussing another aspect of SAP HANA security known as authorization.<\/p>\n<p>Any queries or feedbacks? Drop in the comments section. We will be glad to help you.<\/p>\n<p>Stay tuned with us and explore further tutorials on SAP HANA.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After getting a fair idea of SAP HANA Sidecar, let us explore the different security functions involved in the entire SAP HANA security framework. One such security function used at the initial stages of&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":55794,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19669,19670],"class_list":["post-55761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-sap-hana-authentication","tag-sap-hana-authentication-methods"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>5 SAP HANA Authentication Methods - Must Know for User Verification - DataFlair<\/title>\n<meta name=\"description\" content=\"SAP HANA authentication methods for verification of user identity; username\/ password, kerberos, SAML, SAP logon tickets and assertion tickets and X.509.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 SAP HANA Authentication Methods - Must Know for User Verification - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SAP HANA authentication methods for verification of user identity; username\/ password, kerberos, SAML, SAP logon tickets and assertion tickets and X.509.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-04T09:52:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:43:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-Methods.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"803\" \/>\n\t<meta property=\"og:image:height\" content=\"421\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 SAP HANA Authentication Methods - Must Know for User Verification - DataFlair","description":"SAP HANA authentication methods for verification of user identity; username\/ password, kerberos, SAML, SAP logon tickets and assertion tickets and X.509.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/","og_locale":"en_US","og_type":"article","og_title":"5 SAP HANA Authentication Methods - Must Know for User Verification - DataFlair","og_description":"SAP HANA authentication methods for verification of user identity; username\/ password, kerberos, SAML, SAP logon tickets and assertion tickets and X.509.","og_url":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-04T09:52:50+00:00","article_modified_time":"2021-12-04T07:43:00+00:00","og_image":[{"width":803,"height":421,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-Methods.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"5 SAP HANA Authentication Methods &#8211; Must Know for User Verification","datePublished":"2019-05-04T09:52:50+00:00","dateModified":"2021-12-04T07:43:00+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/"},"wordCount":676,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-Methods.jpg","keywords":["SAP HANA Authentication","SAP HANA Authentication Methods"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/","url":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/","name":"5 SAP HANA Authentication Methods - Must Know for User Verification - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-Methods.jpg","datePublished":"2019-05-04T09:52:50+00:00","dateModified":"2021-12-04T07:43:00+00:00","description":"SAP HANA authentication methods for verification of user identity; username\/ password, kerberos, SAML, SAP logon tickets and assertion tickets and X.509.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-Methods.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Authentication-Methods.jpg","width":803,"height":421,"caption":"SAP HANA Authentication Methods"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-authentication-methods\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"5 SAP HANA Authentication Methods &#8211; Must Know for User Verification"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/55761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=55761"}],"version-history":[{"count":12,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/55761\/revisions"}],"predecessor-version":[{"id":104926,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/55761\/revisions\/104926"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/55794"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=55761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=55761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=55761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}