How do you disable “Execute Direct SQL” feature for all the users of your repository?

In Answers with the help of this feature Administrator can debug some issues like….

1) Check physical connectivity to the database .

2) Check report or dashboard performance (Performance Tuning) ..etc…

It is not a good practice to allow this feature to Production users. There are several reasons ….

1) User can by-pass a data level security defined in the repository .

2) They can overload  production database

3) Users can delete some important database object.

4) They can see some other tables which are not available for them to see…etc…

Process:

We can Disable Direct Database request by the path below.

Answers > Settings > Administration > Manage Privilege 

Provide access to only Presentation Server Administrators.