Skip to Content

Preparation:

Execute SQ02

QV1.jpg

Choose from menu Settings > Settings   to get this Pop-up for your settings

QV2.jpg

Activate “Display system objects”, and then press Enter to adopt the changes.

Make sure that your work area is set to “Standard area” in menu Environment > Query areas:

QV3.jpg

Operation:

Execute transaction SQ01

QV4.jpg

  Click Change Usergroup

QV5.jpg

 

Each User has its own user group for Quickviews. 

The name starts with SYSTQV followed by a sequential number. The user group name says Quick view followed by the User-ID

Choose a desired User group and you get the following view with all the quick views from the chosen user and can execute them

QV6.jpg

To report this post you need to login first.

8 Comments

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

  1. Craig S

    Thanks for the blog!  I haven’t used the process that way.  Maybe you could do a follow-up blog on the reverse sometime.  I don’t often have a need to use other people’s queries but I have often written a query for either a user or a developer.  Sometimes to help the developers with the data set they need to use for a report under development, or for a user to review a prelimanary report under development.  Since a lot of environments are highly regulated such as my industry, (pharma), many wouldn’t be a able to look up and run my query due to security.  Most of the clients I have had, only allow read access to most users for SQVI and never let them write their own queries.  That’s limited to a handful of developers and support personnel.

    But I, (or the appropriate person), can assign a user to my queries, (or anyone else’s) using SQ03.  Once they have run it, reviewed it and commneted on it, I switch them back to their original query group. 

    It’s a very similar process to what you explained just from the opposite direction.

    FF

    (0) 
    1. Jürgen L Post author

      Good idea, just tested it an it worked well. I will extend the blog showing this alternative.

      We had the problem that one guy had created a quick view to extract data for migration. Then he became sick and we needed to execute this quick view. So he was not able to add actively a user to his quick views.

      The usage is very restrictive in our company as well. But it was not meant for endusers, I had consultants in focus.

      (0) 
      1. Craig S

        I knew you did, (have consultants in mind). 

        The illness thing could very easily come in play during a project!  I’m going to keep that in mind!

        Thanks!

        FF

        (0) 
  2. ashish desai

    How can we restrict SQVI to Execute only option? I have created some roles to make it execute only, but I CAN still create query and able to save them as well. Need some input – if any one can.

    (0) 
    1. Jürgen L Post author

      I dont think there is any authorization setting for this. As you can see from this blog it is quite tricky to get to the quickviews of another user.

      With SU24 transaction you can check which authorization objects are assigned to transaction SQVI and SQ02 . Discuss this with a authorizations expert.

      (0) 

Leave a Reply