Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is Getting Started with SAP HANA cockpit and
in this video we will discuss cockpit users.
Hi, I am Denys van Kempen.
In the previous video, we already introduced the Cockpit Manager a bit, how to access,
and what you can do with it, so now we can dive straight in.
I am connected here to the Cockpit Manager as COCKPIT_ADMIN.
You may recall that this user is created during the installation of the SAP HANA Cockpit system.
By default, COCKPIT_ADMIN does not have access to any resource groups, partly, again, by
default, because there aren’t any resource groups created at this stage.
We will talk about resource groups in the next video in more detail.
For now, I will focus on users.
We can Edit the settings for COCKPIT_ADMIN It looks like we can even Delete COCKPIT_ADMIN
but this delete request will fail as you cannot delete the account you are connected with,
the current user.
It would have been a really bad idea to start with as we would no longer have an account
to connect to cockpit.
So, keep that in mind.
If I select Edit, I can change the password and change the Cockpit Roles.
Now, I am going to leave this default user account as-is for now and add a new user instead
with the Create User button here on the left side below.
This way, it will be a little bit easier to explain what purpose all the different roles
have.
Create User Enter the User Name.
I will use Agnetha.
Enter the Password.
Cockpit Manager will create a SAP HANA database user for us, so the default password policy
applies and as mentioned before, HANA cockpit runs on a SAP HANA, express edition system,
so you could easily change this password policy, should you want to, there are videos on how
to do this on the Academy in the Administration playlist.
Confirm the password.
Remember that by default, SAP HANA will request a new password on first logon, again, you
can switch this off - but this also applies to the user we are creating here - and finally,
a valid email address.
Step 2.
Cockpit Roles There are four roles, as of Cockpit SP 05,
service pack 5, that is.
I have mentioned before that Cockpit is aligned with the major SAP HANA support package stacks
(SPS) but that it has its own release cycle as well.
The Cockpit User Role is already selected for us, and you will need to select as least
one role, and this role is required to access cockpit.
Not cockpit manager, but the actual HANA cockpit to manage your resources, your HANA databases.
The other three roles, cockpit administrator, cockpit resource administrator, and cockpit
user administrator, only grant you access to parts of the cockpit manager application,
not to cockpit.
Let’s start with user administrator.
Step 3.
Resource Groups.
Well, there aren’t any at this stage.
So let’s create our user.
Great.
Now let’s connect as Agnetha.
I will open a new incognito window, otherwise I would first have to log off as COCKPIT_ADMIN.
I have saved the Cockpit Manager as a bookmark.
Log On As mentioned, the FORCE_FIRST_PASSWORD_CHANGE
is in place, so we will need to change our password.
OK.
Note that there is no back menu item.
If we switch to our COCKPIT_ADMIN session, we can go back and select another category,
Cockpit Settings, for example.
Also, there is no link Go to SAP HANA Cockpit for Agnetha on the task bar below.
If we try to access Cockpit, we will get a not authorized message.
Ask the cockpit administrator to launch the cockpit manager tool and provide you with
authorization.
What Agnetha can do, of course, is create users.
Now, instead of entering user name and password, the confirmation and the email multiple times,
and maybe make a typo, we can just tick the box: Enable an existing user to access the
Cockpit.
Here, I have a bit of SQL, creating three users, I have switched off the force first
password change so you do not have to watch me changing passwords all the time - do not
use this in production, of course - I have also commented out create user for agnetha
- we already did this - and then a select to check that the users have been created.
Let’s run this.
OK That is looking good.
Back to the Cockpit Manager.
Let’s pick Björn.
Step 2.
Let’s select the Administrator Role, so Björn can modify cockpit settings.
Björn would like that.
I will deselect the Cockpit User Role, just Administrator.
Enable User, the name of the button has changed - and the user has been… enabled.
OK Let’s connect.
As you can see, Björn can now change Cockpit Manager settings but cannot access any of
the other categories of Cockpit Manager or access Cockpit itself.
Not authorized.
We will discuss Cockpit Manager settings in another video, so I will close this window
again.
Back to you, Agnetha.
Next, we need to have a user that can create resource groups and register resources and
this we will address in the next video.
Thanks for watching.
You can find more video tutorials on our YouTube channel.
If you would like to be informed about new video tutorials, please subscribe to our channel.
You can connect with us on LinkedIn or follow us on Twitter, as well for updates
And if you are watching this video on YouTube, do not hesitate to leave your comments to
the video page and, if you like, give us your vote on this video.
Thank you for watching.