Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘Security’ Category

Column level Security 10g

Posted by Santosh Kumar Gidadmani on February 21, 2011

It is very simple to implement a column level security.

1. Identify which column needs security.
2. On the RPD presentation layer, navigate to the subject area, table and the column which you want to enforce security.
3. Double click to open the column property and click on permissions.

4. Uncheck everyone option and select only users or groups you want to show that column.
5. Save the RPD.
6. Create a report with required columns including this column (Quantity_Sold)
7. Login with users whom we have selected in the column permission tab.
8. The report will show with all columns because we have enabled for these users.

9. When you login with other users with whom we have restricted column access. You would see error as below.

10. Simple trick to fix the issue
11. Open the NQConfig.INI file, you would find “PROJECT_INACCESSIBLE_COLUMN_AS_NULL under security section.
12. By default this option will be “NO”, change to “YES”.
13. Save the file and re-run the services.
14. Login with any users, the report will show all the columns who have access to it and it will show all columns except the restricted column for those who do not have access to that column.

15. Though we have the Quantity_Sold column in this report, it is not showing because the user doesn’t have the column access.

– Santosh

Posted in OBIEE 10g, OBIEE 10g RPD, Security | 4 Comments »

%d bloggers like this: