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

Post a Comment

Popular posts from this blog

SQL DATA TYPE

More importantly, the major HANA SQL data types you need to know to work on a real project. These will be enough for most of the scenarios you face. It mainly Effectes on the real time project as on the basis of the views we are creating.
Post a Comment
Read more

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

Post a Comment
Read more

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)
Post a Comment
Read more