This series is based upon SAP HANA on premise and SAP HANA, express edition - HANA 2.0 with XSA and SAP Web IDE for SAP HANA. Originally recorded in January 2019.
In this video, we will create a synonym in order to access a table within a non-container traditional schema. This exercise requires that you have the SFLIGHT catalog schema installed in your system and a database user who has access to this schema.
You can find more information on loading SFLIGHT into your system, if it doesn’t exist already, here:
[ Ссылка ]
The commands to create the SFLIGHT technical user and role are:
CREATE USER CUPS_SFLIGHT PASSWORD "********" SET PARAMETER CLIENT = '001';
ALTER USER CUPS_SFLIGHT DISABLE PASSWORD LIFETIME;
GRANT SELECT ON SCHEMA SFLIGHT TO CUPS_SFLIGHT WITH GRANT OPTION;
GRANT SELECT METADATA ON SCHEMA SFLIGHT to CUPS_SFLIGHT WITH GRANT OPTION;
CREATE ROLE SFLIGHT_CONTAINER_ACCESS;
GRANT SELECT, SELECT METADATA ON SCHEMA SFLIGHT TO SFLIGHT_CONTAINER_ACCESS WITH GRANT OPTION;
GRANT SFLIGHT_CONTAINER_ACCESS TO CUPS_SFLIGHT WITH ADMIN OPTION;
