cancel
Showing results for 
Search instead for 
Did you mean: 

Mass deletion of analysis authorizations in BW 7.0

0 Kudos

Hello all,

since there is no mass maintenance tool in BW 7.0 (especially for deleting AAs), is it safe to write a small ABAP program that deletes the contents from the related tables, e.g.:

DELETE * FROM RSECVAL WHERE TCTAUTH <> '0BI_ALL';

DELETE * FROM RSECHIE WHERE TCTAUTH <> '0BI_ALL';

DELETE * FROM RSECTXT WHERE TCTAUTH <> '0BI_ALL';


Did I miss something? Any other relations?


Thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)

sander_vanwilligen
Active Contributor
0 Kudos

Hi Justin,

I don't recommend to go into this direction.

In my SAP BW 7.31 system there are 41 RSEC* tables so focusing on only 3 tables will not do. The safest way is to do the job using t/code RSECADMIN.

Please also note that those Analysis Authorization objects can be used in PFCG Roles. Standard SAP user interface will take those kind of dependencies into account.

By the way, there is in SAP BW 7.31 a Mass Maintenance function in RSECADMIN. You can also delete multiple Analysis Authorization objects.

Best regards,

Sander

0 Kudos

Once again, I'm on BW 7.0 - and there is no mass maintenance tool.

PFCG roles only have a value reference set in S_RS_AUTH.

Answers (1)

Answers (1)

Loed
Active Contributor
0 Kudos

Hi Justin,

I will just delete them manually in RSECADMIN..Or create an LSMW to automate the deletion if they are too many..

Regards,

Loed

0 Kudos

Not very efficient when deleting large amounts. However, at the end, I'm now using this as a workaround.