Hiding SQL report structure in query manager

[Former Member]

Hi All,

I would like to write a report but not save this as a view or stored proc.

It must be saved and run from within the Query Manager, but the user (including super-user) must not be able to edit/read the code.

Any suggestions as to how best to do this?

Regards,

Kiran

Bluekey Software Solutions

[Former Member]

Hi Kiran,

In B1 design, super user has inherited all authorizations. It is not possible to hide anything from them unless by a hidden SP.

Thanks,

Gordon

[Former Member]

Hi

You can not set any type of authorizations to super users as per SAP behaviour

[Former Member]

Hi,

     In General Authorization, set Read-Only for Query Manager. But it is not possible for Super User.

Try this....

Regards,

Priya

[Former Member]

Hi Kiran..........

You can write a simple SQL report and save it to the Query Manager.

And you can make No authorization for the user so that they can not modify the SQ Queries......

Regards,

Rahul

[KennedyT21]

Hi Kiran,

This Is not Possible for the super user in the current SAP System behavior . For normal user you can achieve this...

Regards

Kennedy