“The object *** is not available for query by any user due to permission setup” issue in OBIEE 11g, Presentation Layer object permission issue in 11g

Standard

Hi All,

I found a common issue in OBIEE 11g while consistency check, all presentation objects are set with no access permissions initially, if rpd is created newly in 11g.

We can go ahead for each object properties then change it’s permissions to Read, but this is manual and time consuming process.

I’ve a tip for this, but may have better & proper solution than this. I’ll definitely get back if I found as such, till the time we can use this as temporary solution which has no issues..

 

1.       Copy (Ctrl + C) entire Subject Area from presentation layer to any editor, which is UDML content..

 

2.       Now, find this text: PRIVILEGES ( NONE)


3.       Replace above text with: PRIVILEGES ( READ)


4.       Now, Copy entire content then paste it back to presentation layer.

Note: Above operation will override the existing subject area with permissions turned to be Read.

With the above approach in a single-shot we can suppress the consistency warnings related to permissions issue.

 

Regards,

Kishore Guggilla

Advertisements

5 responses »

  1. Thank you for the workaround. But we couldnt paste it back. Its giving the error “Metadata script execution error”. Please let us know at vmehta@marvel.com if you have encountered such scenario. Also, do you have any other workarounds to avoid this issue? Did oracle provide any fix for this because I dont see any hits with this issue? We have obiee 11.1.1.5.

    Thanks in advance.

    • Hi

      You could try a slightly modified approach

      1. Cut (Ctrl + X) entire Subject Area from presentation layer to any editor, which is UDML content (Use Notepad)
      2. Now, find this text: PRIVILEGES ( NONE)
      3. Replace above text with: PRIVILEGES ( READ)
      4. In BI Tool, popup arises – if you want to delete the presentation table – click YES
      5. Now, Cut entire content from notepad and paste it back to presentation layer.

      Enjoy your red bull

      Regards

  2. Try not to select anything and paste back.For ex. click on the blank space below the presentation subject areas so that nothing is selected and then paste.It works.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s