Hi HANA security experts,
I have developed a procedure and view and used both of them in the Dynamic Analytic privilege. I was able to see only those values last week which are present from the output of the procedure. This week, there has been a difference in the roles assigned. PUBLIC role is assigned to the test user and I am able to see all data which defeats the very purpose of security. Since PUBLIC role will be added by default once a user is created, I would like to know how to override this role or is there any other way to add other roles that can override the public role. Or Will there be any issues if the public role is removed from the Test user.
Thanks in advance