Skip to main content

how to Grant the Schema

how to Grant the Schema :-
GRANT SELECT ON SCHEMA "SCHEMA NAME" TO _SYS_REPO WITH GRANT OPTION
(We can give semicolon";" also at the end of the statement.






Comments

Popular posts from this blog

How to convert SQL SCRIPT TO GRAPHICAL CALCULATION VIEW in "SAP HANA SP12"

SAP HANA

SAP HANA :- how to Add a primary key to the tables in an Attribute views using Sementics.

PAYMENT DUE DATE CODING4

Coding for Payment Due Date :- 1}Create two new fields by using below Logic: 2} (1) Payment_due_date = if "SHKZG" ='S' then Date(ZFBDT) , else add days between Date(ZFBDT) and int(ZBD1T)