Skip to Content

Some companys had choosen to use SQVI and SQ01 widely. The Problem occurs when you try to reduce the usage of S_TABU_DIS authorisations. If you are happy and on a 7.xx release you can choose to use S_TABU_NAM authorisations instead. Still you need to now which tables are used within SQVI and SQ01.

The Package SQUE contains everything related to this transactions

/wp-content/uploads/2013/02/20130207_11_0000_182718.png

While there are also some usefull Programms to create and maintain Queries of all sorts – there is also the following report to analyze the usage:

RSAQDEL0

/wp-content/uploads/2013/02/20130207_11_0001_182719.png

Here you can choose wether just to analyze which queries exists or also to analyze which tables are used within:

/wp-content/uploads/2013/02/20130207_11_0002_182730.png

If you just want to analyze SQVI Queries you have to restrict InfoSet on SYSTQV*

/wp-content/uploads/2013/02/20130207_11_0003_182737.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Former Member

    This is some good information.  In addition to the security aspect, I work on a lot of upgrade projects and a lot of times these are created by end users directly in their production systems.  This would be very helpful for the planning stages of projects  so customers can identify these and plan for testing, replacement, etc.

    Thanks.

    (0) 

Leave a Reply