I am experiencing the same problem. Where can I find this right? If I go to CMS\BusinessObjects Enterprise Applications > Web Intelligence >
Advanced Rights for groups, I can’t find the ‘View SQL’ right… I get the problem at creating a new Webi document. I first have to save it in my favorites before I can view the SQL. Any help would be appreciated. Thanks.
You can find it in Home>Settings click on Rights then for administrators Net Access (Advanced) click on Advanced, then look for Web Intelligence document you will see View Sql right. By default is not specified.
Thanks, but if I change it there it is still not helping. Even if I change it for the everyone group it doesn’t work . It remains very unclear how BO uses the rights and to see which rights are set.
I just get the error message ‘Your security profile does not include permission to view the SQL generated by the query. (Error: WIS 30256)’. And I only get it at creating a new Webi report without saving it first. By the way, we are still at SP3. Changing the right at Home\Settings doesn’t help and changing the right for the folders doesn’t help (which is logical because the report is not saved yet). So unless there is another place where this right can be set, another right must be involved or there are some conflicting rights somewhere. Thanks.
Thanks for your help, but as said before this is what I do and which doesn’t work. I will try to get to the SAP post and see if that will help. Thanks.
I was now able to read the SAP note, but unfortunately it doesn’t help me. I can’t even see a right called ‘View SQL’, see attached screenshot. That would mean we are not running SP3 right? But I am quit sure we do. Do you know how I can be sure of the version we are running? Thanks.