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

How to set default schema of analytic privilege

156 Views

Hi,

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!

Upamanyu