This content has been marked as final. Show 4 replies
If it is user base then do it on obiee since you got user at rpd and security would be at one place ie. obiee. If it is related to entire application wise then do it on db side.
If helps mark
My users are coming from LDAP.
I want to know by performance wise which one is better.
Because as maintenance VPD looks better.
What is good go with that. Its all about how you maintain thats it.
I think you already have answer with you.
you will have some degree of performance degradation with either approach since you are adding additional filters so I would not use that as the main factor to decide. You need to assess your actual requirements. What is the basis by which you are planning on doing the security. Is LDAP the main basis for the security? Do you plan to use certain roles? if your security is more based on roles at the application level, then it may be easier to define at the Application level (OBIEE)...if its just based on a certain user ID for a set of tables, then perhaps VPD can work. If helpful, pls mark.