You can specify the language and the default schema as metadata declarations in a SQL Script procedure when you use the SAP HANA Deployment Infrastructure (HDI). The language declaration defines the language mode of the procedure, which can be SQLSCRIPT or SQL. The default schema declaration defines the schema that is used to resolve unqualified object names in the procedure body. These declarations are optional and can be specified after the procedure name and before the parameter list. For example:
CREATE PROCEDURE MY_PROCEDURE LANGUAGE SQLSCRIPT DEFAULT SCHEMA
MY_SCHEMA ( ... )
The other options are incorrect because security and authorization are not valid metadata declarations for SQL Script procedures. Security and authorization are handled by the HDI framework, which automatically grants the necessary privileges to the technical users and roles that access the HDI container objects. You do not need to specify any security or authorization clauses in the SQL Script procedure definition. References:
* Procedure Metadata - SAP Help Portal
* CREATE PROCEDURE Statement (Procedural) - SAP Help Portal
* SAP HANA Deployment Infrastructure - SAP Help Portal
* HA150 - SAP HANA 2.0 SPS06 SQLScript for SAP HANA - SAP Training