Retail Price Management (MOSC)

MOSC Banner

Permission id in RPM

edited May 14, 2014 12:00PM in Retail Price Management (MOSC) 1 commentAnswered

Dear RPM Support Community,

We are on RPM 12.0.10

What is Permission id  and use of permission id in RPM?

I would like to know the list of all users in rpm with there privileges , so we ran the following query and found one user is having multiple permission id's , which we cant understand  the exact privileges user had.

(Like whether user can create promotion,price change approval etc)

Kindly help me on this as it is very urgent for me to generate a report.

Query:

select ur.user_id,ur.role_id,npd.permission_id,npd.label,rnp.is_view,rnp.is_edit,rnp.is_submit,rnp.is_approve,r.role_description

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center