could anybody help me to determinate that disadvantages ?
Printable View
could anybody help me to determinate that disadvantages ?
1. Exports are more tricky... If you export a table that is protected under OLS and you want to import to another database, then that database schema must also have OLS installed with label column defined
2. When you create a new user in the database you must consider the label privileges for every new user.
3. Your algorithm for implementing OLS against your business needs some times takes **a lot** of thought (like it did for me). I needed triggers on many OLS protected tables for my business algorithm.
Your question inspired me to go to the documentation to see if anything else. I found:
4. We need to analyze the schema LBACSYS for performance reasons. I didn't know this.
5. It is advised to build indexes on the label column. I didn't know this either though it makes sense.
6. I also need to read in the documentation: "Using OLS with Distributed Database"....which includes sections on Replication considerations while using OLS.