OBIEE 11g: Updating Presentation Layer Permission for all Columns in RPD (.rpd)

So far I have not been able to find an easiest way of changing permissions in the RPD for all columns; as you know setting the permission for the presentation table does not mean that all columns will have the same security level. Below is the easiest way I found:

1. Copy all Presentation Tables from Presentation Subject Area.

   

2. Paste it in universal editor (i.e. Notepad++); Notice that it has privilege settings for all columns:

    

  

3. Now you can replace current privileges with one of the available options: READ, READ_WRITE, NONE and vice versa.
4. Once done, copy from editor and paste directly into the subject area
      a. Note: this will create duplicate presentation tables with #1 at the end of the table name(s).

          

5. Delete original presentation tables and delete #1 from pasted table names.
      a. Note: Column names do not change, only presentation table name changes alone.

If anyone has an alternative solution, please share! :)

Hope this helped!