Hi, Welcome to the SAP HANA Academy
My name is Julie. In this series of videos, we are looking at the new SAP HANA Express edition.
In the first few videos we walked through the installation and configuration of our SAP HANA running in our virtual machine.
We also showed you how to connect to that virtual machine database, using the Eclipse tools.
The next thing we want to do is we want to start working with it
So I can open up Eclipse
I've made sure that my virtual machine is up and running and that I'm logged into my HANA database.
If I look at the icon up here,
it shows the little green square that means it's now connected.
if when I first turn it on, and I've just started up my virtual machine, it might take awhile for it to actually connect,
and have all the services start up. In that case, you would see there's a little grey diamond there instead.
So we want to wait until it's a little green square that we're actually logged on to the system
And that the system is up and running.
We're actually logged on using the system user here.
It shows the user that you're using for that particular connection in the parentheses
Normally when we're working with in SAP HANA, doing modeling or development work
we don't want to do that under the system user.
So, we want to set up a separate user that has the unique rights and roles and privileges
Needed to be able to do whatever the work is that we're going to do
Let's walk through how we can set up a user to do some modeling,.
So if we go to Security and we right click on users and say New
it'll open up the Security Editor
Here, we can create a user and
I want to put in a temporary password because I'm going to have it prompt them to change it on first login.
Then I can also set up date
So if I want to just have this work for the next 15 days or three months etc. I can certainly do that
The next thing I want to do is I want to make sure that I grant the right roles and privileges and access for the user
We're just going to do some modeling, so let's go ahead and choose Modeling and Content
Click OK
I won't restrict anything else because we're just working within our VM here.
So there's lots of videos on the HANA Academy that go through what all the different privileges allow.
Let's go ahead and save that
Now if I go to our security and I refresh and look at my users,
I should see my new user
Now what I want to do is log into my system,
but this time I want to log in as the new user
So now I'm doing my modeling work
With my new user that I just set up.
I'll type in my new username
I'll put in the password and
It's going to prompt me to change my password, so I will do that
Okay, so our next step is to create a schema so I can click on my system connection again,
and using the open SQL console window, I can simply say I create schema, and we'll call it 'STS'
and then click execute using the green "execute" icon.
Refresh the system.
In my catalog I now see an 'STS' schema. Note that if I click on my user
My user does not have that schema listed in their connection,
so what I need to do is I need to grant some rights and privileges to my user
to be able to see and work with the 'STS' schema,.
The first one we're going to do is we're going to do a grant select on schema sts to my user
Now if we refresh the catalog for my user. We should be able to see this 'STS' schema listed.
The next one is we want to do grant select create any on schema 'STS' to my user.
That allows them to create any kind of objects or select any kind of objects within the repository.
Okay, and then the last one we want is Grant access to _SYSREPO
which is actually the system repository for the objects within this catalog.
We'll need to have that for modeling. So we'll go ahead and execute that
Now our users should have all the rights that they need to get us started.
If we find that we need more, we can always come back and either run them through a script
We can actually start creating that script for additional users we need to create in the future
or we can do it through the editor.
Again, all of the Roles and Rights are explained in the help guide,
and then also in the other HANA Academy videos,
where we show doing some of the additional functions with SAP HANA.
So the next video, we'll take a look at loading in some data.
Thanks for watching