Skip to Content
Apr 19, 2018 at 11:10 PM

How to set default schema of analytic privilege



Can anyone help me understand how we can set the default schema for analytic privilege in HANA. I created the analytic privilege using the graphical interface and was never asked to define the schema anywhere. However on checking the table STEUCTURED_PEIVILEGES I could see the default schema set as the user who created/activated the Analytic Privilege. This is leading to error in production where the developer ID used to create the AP in Dev is not present in prod.

Thanks in advance!