{"id":47661,"date":"2019-01-25T15:30:17","date_gmt":"2019-01-25T10:00:17","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=47661"},"modified":"2021-12-01T19:42:31","modified_gmt":"2021-12-01T14:12:31","slug":"sap-hana-studio-administration-console","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/","title":{"rendered":"SAP HANA Studio Administration Console &#8211; Add Schema, Table, User"},"content":{"rendered":"<p>This lesson is about the Administration Console or view in <strong><a href=\"https:\/\/data-flair.training\/blogs\/sap-hana-studio-overview\/\">SAP HANA Studio<\/a><\/strong>. Here, we will learn about the Administration Console perspective found in the SAP HANA Studio. Also, we will learn how to add new systems, create a schema, adding new data tables in the schema, loading data in those tables and adding new users to access specific data tables.<\/p>\n<p>So, are you excited to learn SAP HANA Administration Console?<\/p>\n<h2>SAP HANA Studio Administration Console\/ View<\/h2>\n<p>Administration Console view is one of the many perspectives offered to work in the SAP HANA Studio.\u00a0SAP HANA Studio is an Eclipse-based tool which serves as both the central application development environment as well as the core administration and monitoring platform for the HANA system.<\/p>\n<p>You can select the Administration Console from the first window that appears upon opening the SAP HANA Studio.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/sap-hana-installation-guide\/\">Do you know How to Download and Install Latest SAP HANA?<\/a><\/strong><\/p>\n<div id=\"attachment_47663\" style=\"width: 1918px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47663\" class=\"size-full wp-image-47663\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1.png\" alt=\"SAP HANA Studio, sap hana administration console , sap hana studio administration console, HANA Administration Console, SAP HANA Administration\" width=\"1908\" height=\"984\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1.png 1908w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1-300x155.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1-768x396.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1-1024x528.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1-520x268.png 520w\" sizes=\"auto, (max-width: 1908px) 100vw, 1908px\" \/><\/a><p id=\"caption-attachment-47663\" class=\"wp-caption-text\">SAP HANA Studio\u00a0Administration Console<\/p><\/div>\n<p>The SAP HANA Studio Administration Console opens. However, in some cases, it opens directly if it is set as the default browser.<\/p>\n<div id=\"attachment_47664\" style=\"width: 1925px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47664\" class=\"size-full wp-image-47664\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a.png\" alt=\"SAP HANA Studio Administration Console\" width=\"1915\" height=\"988\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a.png 1915w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a-300x155.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a-768x396.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a-1024x528.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-1a-520x268.png 520w\" sizes=\"auto, (max-width: 1915px) 100vw, 1915px\" \/><\/a><p id=\"caption-attachment-47664\" class=\"wp-caption-text\">SAP HANA Studio\u00a0Administration Console<\/p><\/div>\n<p>A lot of administrative tasks can be performed in the SAP HANA Studio such as regulating (start\/stop) services, monitoring the system, user management and authorization, backup and recovery, audit policy and security configuration, license management, alerts and messages, memory management etc.<\/p>\n<p>All of the mentioned activities can be achieved from different tabs present in the administration console such as,<\/p>\n<ul>\n<li>Overview (general management and monitoring)<\/li>\n<li>Landscape (checks if all the services are running)<\/li>\n<li>Alerts (set and view the details of the alerts)<\/li>\n<li>Performance (checks the performance of the system for the activities taking place on the database)<\/li>\n<li>Volumes (details of the data volumes and logs.<\/li>\n<li>Configuration (contains the details of system configuration files)<\/li>\n<li>System Information (to access system information files and queries)<\/li>\n<li>Diagnosis Files (contains the system log files)<\/li>\n<li>Trace Configuration (contains the traces set up information)<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/sap-hana-use-cases\/\">Recommended reading &#8211; Latest SAP HANA Use Cases<\/a><\/strong><\/p>\n<div id=\"attachment_47665\" style=\"width: 1048px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47665\" class=\"size-full wp-image-47665\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2.png\" alt=\"SAP HANA Studio Administration Console \" width=\"1038\" height=\"662\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2.png 1038w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2-150x96.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2-300x191.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2-768x490.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2-1024x653.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-2-520x332.png 520w\" sizes=\"auto, (max-width: 1038px) 100vw, 1038px\" \/><\/a><p id=\"caption-attachment-47665\" class=\"wp-caption-text\">SAP HANA Studio Administration Console<\/p><\/div>\n<h3>How to add a system in SAP HANA Studio Administration Console?<\/h3>\n<p>In order to work on the administration console, we have to load database systems into the Studio. This connects the client (user) to the SAP HANA database. Let us learn how to add data systems in the administration console.<\/p>\n<p><strong>Step 1<\/strong><\/p>\n<p>On the Administration Console view, right-click on the left panel and a drop-down menu appears. Select Add System.. from the menu.<\/p>\n<div id=\"attachment_47666\" style=\"width: 1451px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47666\" class=\"wp-image-47666 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3.jpg\" alt=\" add a system in SAP HANA Studio Administration Console\" width=\"1441\" height=\"889\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3.jpg 1441w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3-150x93.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3-300x185.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3-768x474.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3-1024x632.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-3-520x321.jpg 520w\" sizes=\"auto, (max-width: 1441px) 100vw, 1441px\" \/><\/a><p id=\"caption-attachment-47666\" class=\"wp-caption-text\">Step.1 To add a system in SAP HANA Studio Administration Console<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/sap-hana-features\/\">Have a Look &#8211; 7 Unique Reasons to Learn SAP HANA\u00a0<\/a><\/strong><\/p>\n<p><strong>Step 2<\/strong><\/p>\n<p>Enter the database specific credentials like Hostname, Instance number, description of the database etc. Click on Next to continue.<\/p>\n<div id=\"attachment_47667\" style=\"width: 705px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47667\" class=\"size-full wp-image-47667\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-4.png\" alt=\" add a system in SAP HANA Studio Administration Console\" width=\"695\" height=\"577\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-4.png 695w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-4-150x125.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-4-300x249.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-4-520x432.png 520w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/a><p id=\"caption-attachment-47667\" class=\"wp-caption-text\">Step.2 To add a system in SAP HANA Studio Administration Console<\/p><\/div>\n<p><strong>Step 3<\/strong><\/p>\n<p>To add the system and access the database in SAP HANA Studio, you need to be an authenticated user with authorized username\/ID and password. Then click on Finish.<\/p>\n<div id=\"attachment_47668\" style=\"width: 751px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47668\" class=\"size-full wp-image-47668\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-5.png\" alt=\" add a system in SAP HANA Studio Administration Console\" width=\"741\" height=\"653\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-5.png 741w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-5-150x132.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-5-300x264.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-5-520x458.png 520w\" sizes=\"auto, (max-width: 741px) 100vw, 741px\" \/><\/a><p id=\"caption-attachment-47668\" class=\"wp-caption-text\">Step.3 To add a system in SAP HANA Studio Administration Console<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/sap-hana-books\/\">Follow this link to know the best SAP HANA Books<\/a><\/strong><\/p>\n<p><strong>Step 4<\/strong><\/p>\n<p>The system gets loaded and you can see the hierarchical view of all the components and categories of the system on the panel. For each system, there are four folders, Catalog, Content, Provisioning, Security plus a Backup folder which are dedicated to providing specific services.<\/p>\n<div id=\"attachment_47669\" style=\"width: 1925px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47669\" class=\"size-full wp-image-47669\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6.png\" alt=\" add a system in SAP HANA Studio Administration Console\" width=\"1915\" height=\"762\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6.png 1915w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6-150x60.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6-300x119.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6-768x306.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6-1024x407.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-6-520x207.png 520w\" sizes=\"auto, (max-width: 1915px) 100vw, 1915px\" \/><\/a><p id=\"caption-attachment-47669\" class=\"wp-caption-text\">Step.4 To add a system in SAP HANA Studio Administration Console<\/p><\/div>\n<p><strong>Step 5<\/strong><\/p>\n<p>You can find data tables by drilling down in the hierarchical system folders.<\/p>\n<div id=\"attachment_47670\" style=\"width: 1914px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47670\" class=\"size-full wp-image-47670\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7.png\" alt=\" add a system in SAP HANA Studio Administration Console\" width=\"1904\" height=\"978\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7.png 1904w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7-300x154.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7-768x394.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7-1024x526.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-7-520x267.png 520w\" sizes=\"auto, (max-width: 1904px) 100vw, 1904px\" \/><\/a><p id=\"caption-attachment-47670\" class=\"wp-caption-text\">Step.5 To add a system in SAP HANA Studio Administration Console<\/p><\/div>\n<p>Also, you can perform several operations on the table as shown in the menu in the screenshot below. You can view a table\u2019s content etc. from this menu.<\/p>\n<div id=\"attachment_47671\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-8.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47671\" class=\"size-full wp-image-47671\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-8.png\" alt=\"add a system in SAP HANA Studio Administration Console\" width=\"670\" height=\"1015\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-8.png 670w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-8-99x150.png 99w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-8-198x300.png 198w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-8-520x788.png 520w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/a><p id=\"caption-attachment-47671\" class=\"wp-caption-text\">Step.6 To add a system in SAP HANA Studio Administration Console<\/p><\/div>\n<h3>How to add a schema?<\/h3>\n<p>In the Catalog folder, you can find schemas of all the loaded databases in the system. The schema contains folders which organize a database properly. The folders are Column view, Functions, Indexes, Procedures, Sequences, Tables etc. Let us learn how to add a new database schema.<\/p>\n<p><strong>Step 1<\/strong><\/p>\n<p>Open the <a href=\"https:\/\/data-flair.training\/blogs\/sql-tutorial\/\">SQL<\/a> Console from the icons given at the top after clicking on the database system\u2019s name in which you wish to add a schema.<\/p>\n<div id=\"attachment_47672\" style=\"width: 1912px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47672\" class=\"size-full wp-image-47672\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9.png\" alt=\"How to add a schema?\" width=\"1902\" height=\"988\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9.png 1902w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9-150x78.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9-300x156.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9-768x399.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9-1024x532.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-9-520x270.png 520w\" sizes=\"auto, (max-width: 1902px) 100vw, 1902px\" \/><\/a><p id=\"caption-attachment-47672\" class=\"wp-caption-text\">Step.1 to add a schema<\/p><\/div>\n<p><strong>Step 2<\/strong><\/p>\n<p>Enter the statement in the SQL Console to create the new schema. Name the schema as you like. Click on the green Execute button.<\/p>\n<div id=\"attachment_47673\" style=\"width: 1912px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47673\" class=\"size-full wp-image-47673\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10.png\" alt=\"How to add a schema?\" width=\"1902\" height=\"970\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10.png 1902w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10-150x76.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10-300x153.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10-768x392.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10-1024x522.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-10-520x265.png 520w\" sizes=\"auto, (max-width: 1902px) 100vw, 1902px\" \/><\/a><p id=\"caption-attachment-47673\" class=\"wp-caption-text\">Step.2 to add a schema<\/p><\/div>\n<p><strong>Step 3<\/strong><\/p>\n<p>A new schema with the name Live2 is added in the system.<\/p>\n<div id=\"attachment_47674\" style=\"width: 477px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-11.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47674\" class=\"size-full wp-image-47674\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-11.png\" alt=\"How to add a schema?\" width=\"467\" height=\"913\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-11.png 467w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-11-77x150.png 77w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-11-153x300.png 153w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/a><p id=\"caption-attachment-47674\" class=\"wp-caption-text\">Step.3 to add a schema<\/p><\/div>\n<p>You can add a new table as well by right-clicking on the tables folder.<\/p>\n<div id=\"attachment_47675\" style=\"width: 495px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-12.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47675\" class=\"size-full wp-image-47675\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-12.png\" alt=\"How to add a schema?\" width=\"485\" height=\"877\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-12.png 485w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-12-83x150.png 83w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-12-166x300.png 166w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/a><p id=\"caption-attachment-47675\" class=\"wp-caption-text\">Step.4 to add a schema<\/p><\/div>\n<h3>How to add tables in a schema?<\/h3>\n<p>You can add new tables within a schema through the SQL Console. Enter the code which is a statement specifying all the table details. Click on the green execute button and the table will be added.<\/p>\n<div id=\"attachment_47676\" style=\"width: 1907px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47676\" class=\"size-full wp-image-47676\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13.png\" alt=\"How to add table a schema?\" width=\"1897\" height=\"831\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13.png 1897w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13-150x66.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13-300x131.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13-768x336.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13-1024x449.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-13-520x228.png 520w\" sizes=\"auto, (max-width: 1897px) 100vw, 1897px\" \/><\/a><p id=\"caption-attachment-47676\" class=\"wp-caption-text\">Step.1 to add table a schema<\/p><\/div>\n<p>Refresh the Tables folder in the schema and the newly created table \u201cMember\u201d will appear in the list. You can add more tables like this.<\/p>\n<div id=\"attachment_47677\" style=\"width: 1910px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47677\" class=\"size-full wp-image-47677\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14.png\" alt=\"add table a schema\" width=\"1900\" height=\"964\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14.png 1900w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14-150x76.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14-300x152.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14-768x390.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14-1024x520.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-14-520x264.png 520w\" sizes=\"auto, (max-width: 1900px) 100vw, 1900px\" \/><\/a><p id=\"caption-attachment-47677\" class=\"wp-caption-text\">Step.2 to add table a schema<\/p><\/div>\n<h3>How to add a user in a schema?<\/h3>\n<p>You can add a new user and give it access to the system by going to the Security folder. Right-click on the Users option and select New User.<\/p>\n<div id=\"attachment_47678\" style=\"width: 481px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-15.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47678\" class=\"size-full wp-image-47678\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-15.png\" alt=\"add a user in a schema\" width=\"471\" height=\"509\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-15.png 471w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-15-139x150.png 139w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-15-278x300.png 278w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/a><p id=\"caption-attachment-47678\" class=\"wp-caption-text\">Step.1 add a user in a schema<\/p><\/div>\n<p>Enter the username and password for the new user.<\/p>\n<div id=\"attachment_47679\" style=\"width: 1373px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47679\" class=\"size-full wp-image-47679\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16.png\" alt=\"add a user in a schema\" width=\"1363\" height=\"687\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16.png 1363w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16-150x76.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16-300x151.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16-768x387.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16-1024x516.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-16-520x262.png 520w\" sizes=\"auto, (max-width: 1363px) 100vw, 1363px\" \/><\/a><p id=\"caption-attachment-47679\" class=\"wp-caption-text\">Step.2 add a user in a schema<\/p><\/div>\n<p>We can add a new user to the user&#8217;s list.<\/p>\n<div id=\"attachment_47680\" style=\"width: 481px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-17.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47680\" class=\"size-full wp-image-47680\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-17.png\" alt=\"add a user in a schema\" width=\"471\" height=\"521\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-17.png 471w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-17-136x150.png 136w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-17-271x300.png 271w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/a><p id=\"caption-attachment-47680\" class=\"wp-caption-text\">Step.3 add a user in a schema<\/p><\/div>\n<p>Also, you can grant specific privileges to the new user i.e. they are only allowed to perform certain actions in the system and manipulate data.<\/p>\n<div id=\"attachment_47681\" style=\"width: 1413px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47681\" class=\"size-full wp-image-47681\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18.png\" alt=\"add a user in a schema\" width=\"1403\" height=\"839\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18.png 1403w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18-150x90.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18-300x179.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18-768x459.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18-1024x612.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-18-520x311.png 520w\" sizes=\"auto, (max-width: 1403px) 100vw, 1403px\" \/><\/a><p id=\"caption-attachment-47681\" class=\"wp-caption-text\">Step.4 add a user in a schema<\/p><\/div>\n<div id=\"attachment_47682\" style=\"width: 1423px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47682\" class=\"size-full wp-image-47682\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19.png\" alt=\"add a user in a schema\" width=\"1413\" height=\"833\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19.png 1413w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19-150x88.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19-300x177.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19-768x453.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19-1024x604.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-19-520x307.png 520w\" sizes=\"auto, (max-width: 1413px) 100vw, 1413px\" \/><\/a><p id=\"caption-attachment-47682\" class=\"wp-caption-text\">Step.5 add a user in a schema<\/p><\/div>\n<p>Hence, a new user with the name LIVE2USER is created having access to limited tables and is granted distinct privileges.<\/p>\n<div id=\"attachment_47683\" style=\"width: 485px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-20.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47683\" class=\"wp-image-47683 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-20.png\" alt=\"add a user in a schema\" width=\"475\" height=\"783\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-20.png 475w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-20-91x150.png 91w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-20-182x300.png 182w\" sizes=\"auto, (max-width: 475px) 100vw, 475px\" \/><\/a><p id=\"caption-attachment-47683\" class=\"wp-caption-text\">Step.6 add a user in a schema<\/p><\/div>\n<p>Now, for instance, if we try to delete a table, we will get an error message for restricted user privilege as the user is only allowed to read the table contents and not delete them.<\/p>\n<div id=\"attachment_47684\" style=\"width: 698px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-21.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47684\" class=\"size-full wp-image-47684\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-21.png\" alt=\"add a user in a schema\" width=\"688\" height=\"228\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-21.png 688w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-21-150x50.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-21-300x99.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-21-520x172.png 520w\" sizes=\"auto, (max-width: 688px) 100vw, 688px\" \/><\/a><p id=\"caption-attachment-47684\" class=\"wp-caption-text\">Step.6 add a user in a schema<\/p><\/div>\n<h3>Log Off\/Login in SAP HANA Studio<\/h3>\n<p>You can log in and off a SAP HANA System by right-clicking on the system\u2019s name and selecting Log Off from the drop-down menu. This will end all the existing connections from that system.<\/p>\n<div id=\"attachment_47685\" style=\"width: 758px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-22.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47685\" class=\"size-full wp-image-47685\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-22.png\" alt=\" Log Off\/Login in SAP HANA Studio\" width=\"748\" height=\"450\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-22.png 748w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-22-150x90.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-22-300x180.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-22-520x313.png 520w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><\/a><p id=\"caption-attachment-47685\" class=\"wp-caption-text\">Log Off\/Login in SAP HANA Studio<\/p><\/div>\n<p>You can also log in to the system by doing the same and selecting Log In from the drop-down menu.<\/p>\n<div id=\"attachment_47686\" style=\"width: 739px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-23.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-47686\" class=\"size-full wp-image-47686\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-23.png\" alt=\" Log Off\/Login in SAP HANA Studio\" width=\"729\" height=\"204\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-23.png 729w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-23-150x42.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-23-300x84.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-23-520x146.png 520w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><\/a><p id=\"caption-attachment-47686\" class=\"wp-caption-text\">Log Off\/Login in SAP HANA Studio<\/p><\/div>\n<p>So, this was all about <a href=\"https:\/\/help.sap.com\/viewer\/a2a49126a5c546a9864aae22c05c3d0e\/2.0.01\/en-US\/f64e0e6f622a4217bdbe6b489f7dc690.html\">SAP HANA Studio<\/a> Administration Console. Hope, you liked our explanation.<\/p>\n<h2>Conclusion<\/h2>\n<p>Thus, this is all you need to know about the SAP HANA Studio Administration Console view to start working on it and administering your database systems.<\/p>\n<p>If you have any queries regarding this, drop them in the comment box below.<span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1669,&quot;href&quot;:&quot;https:\\\/\\\/help.sap.com\\\/viewer\\\/a2a49126a5c546a9864aae22c05c3d0e\\\/2.0.01\\\/en-US\\\/f64e0e6f622a4217bdbe6b489f7dc690.html&quot;,&quot;archived_href&quot;:&quot;&quot;,&quot;redirect_href&quot;:&quot;https:\\\/\\\/help.sap.com\\\/docs\\\/r\\\/a2a49126a5c546a9864aae22c05c3d0e\\\/2.0.01\\\/en-US\\\/f64e0e6f622a4217bdbe6b489f7dc690.html&quot;,&quot;checks&quot;:[],&quot;broken&quot;:false,&quot;last_checked&quot;:null,&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This lesson is about the Administration Console or view in SAP HANA Studio. Here, we will learn about the Administration Console perspective found in the SAP HANA Studio. Also, we will learn how to&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":47687,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[18490,18491,18488,18024,18489],"class_list":["post-47661","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-hana-administration-console","tag-sap-hana-administration","tag-sap-hana-administration-console","tag-sap-hana-studio","tag-sap-hana-studio-administration-console"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP HANA Studio Administration Console - Add Schema, Table, User - DataFlair<\/title>\n<meta name=\"description\" content=\"SAP HANA Studio Administration Console - How to Add Schema, adding tables in a schema, adding a user in a schema, Log Off and Login in SAP HANA Studio\" \/>\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-studio-administration-console\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP HANA Studio Administration Console - Add Schema, Table, User - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SAP HANA Studio Administration Console - How to Add Schema, adding tables in a schema, adding a user in a schema, Log Off and Login in SAP HANA Studio\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/\" \/>\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-01-25T10:00:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-01T14:12:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-View-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\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=\"11 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP HANA Studio Administration Console - Add Schema, Table, User - DataFlair","description":"SAP HANA Studio Administration Console - How to Add Schema, adding tables in a schema, adding a user in a schema, Log Off and Login in SAP HANA Studio","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-studio-administration-console\/","og_locale":"en_US","og_type":"article","og_title":"SAP HANA Studio Administration Console - Add Schema, Table, User - DataFlair","og_description":"SAP HANA Studio Administration Console - How to Add Schema, adding tables in a schema, adding a user in a schema, Log Off and Login in SAP HANA Studio","og_url":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-01-25T10:00:17+00:00","article_modified_time":"2021-12-01T14:12:31+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-View-01.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":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SAP HANA Studio Administration Console &#8211; Add Schema, Table, User","datePublished":"2019-01-25T10:00:17+00:00","dateModified":"2021-12-01T14:12:31+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/"},"wordCount":1359,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-View-01.jpg","keywords":["HANA Administration Console","SAP HANA Administration","sap hana administration console","SAP HANA Studio","sap hana studio administration console"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/","url":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/","name":"SAP HANA Studio Administration Console - Add Schema, Table, User - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-View-01.jpg","datePublished":"2019-01-25T10:00:17+00:00","dateModified":"2021-12-01T14:12:31+00:00","description":"SAP HANA Studio Administration Console - How to Add Schema, adding tables in a schema, adding a user in a schema, Log Off and Login in SAP HANA Studio","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-View-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/SAP-HANA-Studio-Administration-Console-View-01.jpg","width":1200,"height":628,"caption":"Introduction to SAP HANA Studio Administration Console"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-studio-administration-console\/#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":"SAP HANA Studio Administration Console &#8211; Add Schema, Table, User"}]},{"@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\/47661","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=47661"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/47661\/revisions"}],"predecessor-version":[{"id":104594,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/47661\/revisions\/104594"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/47687"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=47661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=47661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=47661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}