Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA Cockpit and in this video we will
talk about restricted features.
This video has been recorded on release SAP HANA 2.0 SPS 03 (April 2018) and SAP HANA
cockpit 2.0 SP 07 from August 2018.
For earlier or later releases, please check the playlist on the SAP HANA Academy.
Hi, I am Denys van Kempen.
With Manage Restricted Features you can disable features (functionality) for tenant databases.
You may not want each and every feature of SAP HANA to be available in each and every
environment.
Here in the SAP HANA Security Guide we find them all documented.
It is related to blacklisted system properties, which we will discuss in another video.
There is a whole list.
RINTEGRATION, AFL: This could be a feature that’s not required in all deployment scenarios.
BACKUP, IMPORTEXPORT: Here, the file system access might not be desirable, not wanted.
And so on.
You can query the system view M_CUSTOMIZABLE_FUNCTIONALITIES to get a list of all the features which can
be disabled and the current status.
We will take a look at that in a minute.
In earlier versions, you had to manually configure the global.ini file, customizable_functionalities
section, using SQL.
Today, we can very easily do this using the cockpit.
Let’s connect.
Open our resource directoryand select Manage Databases from the system database for this
instance.
This opens Manage Databases, system HA0 in my case, listing the system and all tenant
databases.
In the header, we can then select Manage Restricted Features.
This will open Blacklisted & Restricted, Restricted Features for Tenants.
Select the tenant you want to apply the restrictions toand then make your selectionfor example,
AFL, BUILTINPROCEDURE
Note that the features are listed in a hierarchy.
So, if we disable the parent, all the children will be restricted as well.
Lets also take DYNAMIC TIERING.
I am just making a pretty random selection hereand then click Save.
Very good.
The boxes are ticked and if we want to enable a feature again, just click the red cross
and confirm with a Yes, or remove the selection mark and save.
Same thing.
New in Cockpit SP 07 is the ability to Copy Restricted Features.
This allows us to copy our selection from one tenant to the next.
We can do this from the system database and make this default for all tenantsor do this
from tenant B and select the configuration from tenant A.
However you want to set this up.
To view our selection we have this view in the cockpit, of course but should you need
to do some reporting and want to compare configurations, you can use the system view.
So, lets execute some SQL
Using the SAP HANA Database Explorer for SAP HANA Cockpit.
Public Synonyms
CUSTOMIZABLE_FUNCTIONALITIES
Features, functionalities —same thing.
Open Data
And here we have our list for the HA0 tenant.
You can set a filter
IS_ENABLED = FALSE
in other words, disabled
And here you can get the SQL
OK —that’s it, so much for Restricted Features.
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.