Authorization Issue While Creating Column View

[Former Member]

Hi Experts

I am trying to Generate a Column View in my Schema (Specific as per requirement) by triggering a Query from ABAP side though i agree that we can create the same in _SYS_BIC schema.

But there is an authorization error for creating the view in any other Schema, Please help me to understand what all authorization will be required to achieve the same.

Code Snippet :

TRY.

LV_SQL_STATEMENT_0 = |CREATE COLUMN VIEW "ZTEST"."zscenario/ZAT_AG" - REST OF THE STATEMENT|.

lo_sql_result_0 = lo_sql_statement_0->execute_query( lv_sql_statement_0 ).

** Few Code Lines**

lo_sql_result_0->next_package( ).

lo_sql_result_0->close( ).

CATCH cx_sql_exception INTO DATA(lr_sql_excep_0).

ENDTRY.

Thanks

Atul Gandhi

[Former Member]

GRANT CREATE ANY ON ZTEST TO USER;