BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

disable custom query


 
Search this topic... | Search CMC... | Search Box
Register or Login to Post    Forum Index -> Security and User Administration -> CMC  Previous TopicPrint TopicNext Topic
Author Message
ndatta
Forum Member
Forum Member



Joined: 11 Sep 2013

Posts: 10



PostPosted: Mon Mar 02, 2015 8:33 am 
Post subject: disable custom query

Hi,

my requirement is to disable custom sql option for users; however these are set of super users woh have full control but should not be able to edit someone else's report and should not be able to customize their own query.

Please find attachment for the refernce of rights given by us.

Please help
Back to top
MBLM
Principal Member
Principal Member



Joined: 31 Jan 2014

Posts: 210


flag
PostPosted: Tue Mar 03, 2015 6:16 am 
Post subject: Re: disable custom query

If they should never be able to use custom SQL (in their own reports or somenone elses)

Can't you just deny the right to (in 4.1SP3):

Query script - enable editing (SQL, MDX ...)

In the group 'Web Intelligence' under 'Application'


Please excuse me if my approach doesn't match your problem icon_redface.gif
Back to top
ndatta
Forum Member
Forum Member



Joined: 11 Sep 2013

Posts: 10



PostPosted: Tue Mar 10, 2015 1:49 am 
Post subject: Re: disable custom query

your approach is correct however I wany it to be enabled for their own reports and disabled for someone else's report
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 13976
Location: London


flag
PostPosted: Tue Mar 10, 2015 4:36 am 
Post subject: Re: disable custom query

ndatta wrote:
your approach is correct however I wany it to be enabled for their own reports and disabled for someone else's report


Usually this sort of thing is managed by folders, edit rights on objects within etc.

_________________
Next Available for Contract Work - January 2018

Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
arnabarnab
Forum Member
Forum Member



Joined: 19 Aug 2020

Posts: 1



PostPosted: Wed Aug 19, 2020 2:53 am 
Post subject: Re: disable custom query

Sorry for reviving an old topic.
Actually we have a mandate of restricting the data pertaining to one country shouldn't be seen by other country in SAP BO reports.
While I have implemented this and it works fine via adding new restriction in the Universe Design Tool, however this doesn't prevent the users to amend the "Use Custom Query Script" and remove the country filter when formulating the report.
Can someone please guide me on how to restrict this option from SAP BO completely? I tried to do the same via CMC and remove View SQL/Edit query option from the folder advanced Web Intelligence from CMC->Folders, however that didn't work.
It's ok to completely disable the option and not for specific folders, can you please guide me on how to the same?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Security and User Administration -> CMC  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0285 seconds using 18 queries. (SQL 0.0032 Parse 0.0009 Other 0.0244)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo