New User ID's - Copy Query Assignment

[vijayendra_rao]

Hello All,

We are in the process of creating new user ID's. I would like to know what steps should I keep in mind so that the new user ID's are properly assigned to the queries.

I have already checked the FM: RSAQ_IMPORT_USERGROUP_CATALOG. But I am not quite sure if I am seeing the right information in there. Under O_DBBN - I only two entries under columns NUM (is this user group?) and BNAME. Does this mean there are only two users in my organization using the queries? (seems unlikely!) Where do I see to which queries these users are assigned? Under O_DBBS - I see 25 entries, it seems to me like these are queries in the current (?) environment. But again, it does not list who are the users.

I would appreciate any help.

Thanks!

Vijay

[vijayendra_rao]

Hi,

I know that this is not an answer to your questions but my advice would be to stop using queries. Create a transaction for each query and use transaction code to control access. Maintaining query assignment does not scale. When you have many users the effort required will be too big and you will always forget to remove assignments. IdM can't handle query assignment nor HR org. structure can.

Cheers

[mvoros]

Hi,

I know that this is not an answer to your questions but my advice would be to stop using queries. Create a transaction for each query and use transaction code to control access. Maintaining query assignment does not scale. When you have many users the effort required will be too big and you will always forget to remove assignments. IdM can't handle query assignment nor HR org. structure can.

Cheers

[vijayendra_rao]

Thanks Martin, that is a good tip indeed. Once the new ID's are implemented, I plan to do this! But I still need to find a way to figure out all the users assigned to the queries. Will keep digging.

Vijay

[mvoros]

Hi,

just use FM RSAQ_READ_QUERY_CATALOG with default parameters. It will give you queries with corresponding user groups and users.

Cheers

[vijayendra_rao]

Thanks Martin!

I think I accidentally deleted the email notification of your post. Looks like this is what I need! But I am doing some due diligence to make sure I am getting what I want. Thanks again! Will update soon.

Vijay

[vijayendra_rao]

The function module is useful in getting list of standard SAP queries, but I don't think it includes Quick View queries. Thanks Martin.

[Former Member]

Hi Vijay

This happened with us as well. If we recently changed userid's.

Basically these queries are personalized queries

Open a query which is already created in SQVI

Then Press SAP QUERY Button on Quick viewer. Then it will lead you to  SAP QUERY.

Menu bar > Environments> Query Areas--- change to Standard areas from Global

Then

Menu bar >Query convert Quick view--> assign infoset name and user group.

Please assign the users to group(where you assigned queries) using Sq03

[vijayendra_rao]

Thanks Pavan.

Looks like this is the approach we will have to take as well as there is no standard procedure to copy over Quick Views. The issue I see with this approach is, as per our table extract from AQLTS (by looking into field Text which also stores username:queryname information) we seem to have over 1000 Quick Views. Manually converting each Quick View to SAP Query does not make sense. How did you execute this? Is LSMW possible? I am creating a LSMW script to test it.

[vijayendra_rao]

Update:

It is possible to create LSMW script for mass copy. I did have to delete screen field entries under SAPMS38R 0050 from LSMW recording. Also, had to use "Display only errors" processing mode (somehow Background processing kept failing).

However, I still have not found a straight forward way to get a list of all Quick Views maintained by each user (for me it will be a manual exercise), unless there is a function module that gives the result?

[Former Member]

Hi Vijay

I never tried LSMW.I have always developed and used Secatt scripts for all the mass changes.

May be you can try , Secatt is easy way. i hope it will fine