Authorizations for Working with a Query 

Use

The authorizations to work with a query were already checked in the dialog box for opening a query.

When a query is opened, the authorizations for the individual objects are checked.

Also refer to: Authorization Check When Executing a Query..

Structure

Check in the dialog to open:

When you want to open a query, you will see four buttons in the dialog box, the History, Favorites and Roles buttons only display you own queries and those queries intended for you per role definition.

The Folder button enables you to look at all queries, for which a user has display authorization. If this display authorization is not restricted to queries, the user will see all available queries in the system there. It is possible to hide the Folder button, if you do not want the user to see all queries in the system. The authorization object S_RS_FOLD with the field SUP_FOLDER is also available. In order to hide the Folder button, set this field to "X" when authorizing, otherwise leave the field blank " " or set it to "*". The button will be displayed if the authorization check fails.

Authorizations by user

It is possible to make queries from certain users (= OWNER = query creator ) available for display or processing by particular users ( = USER). The authorization object S_RS_COMP1 with four fields (COMPID, COMPTYPE, OWNER, ACTVT) is also available.

You can grant this authorization to a particular team or use the variable $USER to give all users authorization for queries that they created themselves. "$USER" is replaced by the corresponding user name during the authorization check.

Also refer to the Example for Reporting Authorizations.

Checking objects:

When a query is opened, the authorization for the individual objects is checked. Refer to Overview: Authorization Objects

See also:

Authorizations for Selection Criteria

Authorizations for the Query Definition

Authorizations for Display Attributes

Authorizations for Hierarchies

Authorizations with Variables