DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Label Security Option, disadvantages

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Post Label Security Option, disadvantages

    could anybody help me to determinate that disadvantages ?

  2. #2
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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.
    Don't blame me, I'm from Red Sox Nation.

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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.
    Don't blame me, I'm from Red Sox Nation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width