SAP Trials - SAP NetWeaver 7.5 SP1 AS ABAP and SAP BW on SAP HANA - Annotations (2)

Creating artifacts via SQL: do not have benefit of creating the objects in the repository, no transport or versioning;

Catalog artifact:

- Creating schema: file suffix <schema_name>.hdbschema

- Creating table: file suffix <table_name>.hdbtable

<tablename>.hdbtable - A syntax used to define a design-time representation of a table

What is the main advantage of the design-time approach to data modeling? Transportability of data models between SAP HANA systems

- Creating sequences: file suffix <sequence_name>.hdbsequence

- Creating views: file suffix <view_name>.hdbview

- Creating roles: file suffix <role_name>.hdbrole

Related to file .xsprivileges

System user _SYS_REPO is the owner of the objects.

Grant authorization to user - call stored procedure: call _SYS_REPO.GRANT_ACTIVATED_ROLE('sap.hana.democontent.epm.roles::Admin','SYSTEM');

Wrong way to get authorizations:

After creating the schema, it is not visible under Systems -> Catalog; Execute the following SQL:

call _SYS_REPO.GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT(
                'select, create any, insert, delete, update, execute, alter, drop',
                'WORKSHOPA_00',
                'SYSTEM');

References:

- http://saphanatutorial.com/sap-hana-xs-create-schema-using-hdbschema-file/