Please can anyone advise if it is a fine practice to have multiple schemas in HANA :
- Schema 1: Accounts Payables
-Schema 2: General Ledger
- Schema 3: Account Receivables
At present we need ability to classify RUNTIME Catalog objects like TABLES and Stored Procedures under its Schema
Doing this, does it have any performance issues or limitation on Security and Privileges etc ?