How to get the list of user's profile and privileges in SAP PowerDesigner 16.7 using vbs

[SAPSupport]

How to get the list of user's profile and privileges in SAP PowerDesigner 16.7 using  vbs?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

You can find the necessary info to build you own custom code, ang the info you are looking for (the list of user's profile and privileges in SAP PowerDesigner 16.7 sp07 using VBS) by opening the metamodel objects help. From there you may look into RepositoryUser, RepositoryDocumentBase (.GetPermission).

See KBA# 3451439-How to get the list of user's profile and privileges in SAP PowerDesigner using VBS - PD

You can also get some relevant information from KBA#  2767881 - How to get the list of groups, members and their rights - SAP PD  Which treats the same bu...

[arnaud_laurent]

Hello,

This isn't VBS, but note that you may also query the database to retrieve the list of repository users/groups and their respective privileges.

SELECT name AS Member,
CASE WHEN (rght & 1=1) THEN 'Y' END AS Cnnect,
CASE WHEN (rght & 2=2) THEN 'Y' END AS Freeze,
CASE WHEN (rght & 4=4) THEN 'Y' END AS Lock_Docs,
CASE WHEN (rght & 8=8) THEN 'Y' END AS Mng_Branches,
CASE WHEN (rght & 16=16) THEN 'Y' END AS Mng_Configs,
CASE WHEN (rght & 32=32) THEN 'Y' END AS Mng_All_Docs,
CASE WHEN (rght & 64=64) THEN 'Y' END AS Mng_Users,
CASE WHEN (rght & 128=128) THEN 'Y' END AS Mng_Rep,
CASE WHEN (rght & 256=256) THEN 'Y' END AS Edit_Web,
CASE WHEN (rght & 512=512) THEN 'Y' END AS Edit_Ext_Web
FROM pmuser
ORDER by name

Additional information is available in KBA  2767881 - How to get the list of groups, their members and their rights
Kind regards