Learning notes from the learning journey: Installing and Administering SAP HANA to take the Certification “SAP Certified Associate – Database Administrator – SAP HANA”.
Locating Database in SAP HANA Cockpit:
DATABASE DIRECTORY: display an aggregated view of all the registered databases that are in a group to which the user has granted access.
To access this, use the SAP HANA Cockpit.
DATABASE MANAGEMENT: Display information about all databases in the database system, besides monitoring and admin the tenant databases.
To perform operations on a tenant database :: system privilege DATABASE ADMIN.
Blocklisted Parameters – allow control system config. changed by individual tenant db. (stored: multidb.ini) :: system privilege INIFILE ADMIN~
To access this, use the SYSTEMDB.
DATABASE INFORMATION CARD :: system privilege CATALOG READ