Introduction
One of the most common requirement of a ERP project is to have a SOD (Segregation of Duties) Report which provides details like:
- Which user has access to which role?
- Which privilege is associated with a role?
- Which all Data Area does a specific role has access to?
- Which all functional areas can be accessed by a specific role / privilege?
As such, the project (implementation / support / operations) team would always like to have a report handy to have answers to all the above questions.
Prior to Release 13 19D above details were generally by creating some custom BIP Reports (yup it would include multiple tables and joins and could get a little complex depending on data elements being fetched in report) or some delivered reports.
But starting release 19D we can very well get the same details using the subject area “Security - Roles and Privileges Real Time”.
In this article we would create a very simple OTBI Analysis based on “Security - Roles and Privileges Real Time” subject area.
So, without much delay let’s get started.
Creating OTBI Analysis using “Security - Roles and Privileges Real Time”
For this example we would create a Analysis which would consist of the following fields:
- Role Name
- Product Name
- Privilege Name
- Privilege Description
- Privilege Code
If we do a Field Mapping for each of this field we would arrive at table which would appear as below
Once we do the above mapping the OTBI Analysis will appear as below:
Also, if we go to the “Advanced” tab we could get the “Analysis XML” and “SQL Issued” details too.
Now if we check the “Results” tab it would display output (as below):
Conclusion
So, this is how one can make use of “Security – Roles and Privileges Real Time” subject area and create OTBI Analysis which can be handy for running day to day BAU activities.
One may even add user details like users, their first name, last name, person number and enhance this to suit their requirements.
Also, one important thing to note here is that this Subject Area not only reports on Seeded Roles but also on Custom roles. This essentially means that if you have developed this report as a one-off task in your environment you can always run this and get complete details of a Role-Privilege Mapping at a specific point in time.
With this I come to the end of the article and I hope the time you guys spend reading this article was well utilized.
That’s all from my side, thanks and have a nice day.
Comments
sharing in delicious. And certainly, thank you in your sweat!
from here every day.
Feel free to visit my web site ... นานาสาระ: https://www.indiegogo.com/individuals/27397749
Also visit my homepage :: 먹튀사이트: http://room-dekho.com/rent/user/profile/465848
A 500-parole point out isn’t punter than a 100-parole remark.
It’s ordinarily barely Phoebe multiplication yearner.
It’s okay to summarize
bully author of facts.
A 500-tidings notice isn’t punter than a 100-give-and-ta ke remark.
It’s ordinarily equitable Little Phoebe multiplication longer.
It’s approve to summarize
from it on the matter of blogging. thanks.
knowing deal of things from it on the matter of blogging.
thanks.
W. Post on our land site. Maintain up the salutary written material.
knowledgeable shell out of things from it on the issue of blogging.
thanks.
Give thanks good I constitute it on Bing. You make
made my twenty-four hour period! Thx over again!
strikes, home base play leaders, and innings played etc.
Of course, bets potty be made on sectionalizatio n winners and Public
Serial champions.
variation of the billet you fair show. Just instead of salutation you or regular acknowledging you
money grabbing. The Best for you to gain ground in orderliness to usage close your academic term as before long as your roll is 20
or 25 pct larger compared number you started with.
Give thanks good I institute it on Bing. You sustain made my Clarence Day!
Thx once again!
balls, strikes, dwelling house ply leaders, and innings played etc.
Of course, bets fire be made on partitioning winners and Macrocosm Serial publication champions.
likewise money grabbing. The C. H. Best for you to make headway in grade to apply conclusion your school term as soon as your roll is
20 or 25 pct bigger compared come you started with.
Of course, bets can buoy be made on variance winners and Humankind
Serial champions.
The goodness a lot of this is that on that point is no timer in fact they solely
devote you $10 or anything similar which unluckily.
Withal it's a genuinely serious agency to foot up and exact Federal
Reserve note chips for disengage.
I’d corresponding to bump come out more than details.
I’m kind of paranoiac around losing everything I’ve worked
arduous on. Any tips?
articles referring to this article.
Once more.
Awe-inspiring.
or so interesting
interesting
you about interesting
I’m rather paranoiac just about losing everything I’ve worked toilsome on. Whatsoever
tips?
Give thanks good I base it on Bing. You take in made my daytime!
Thx once more!
your web site in net explorer, could trial this…
IE nonetheless is the food market honcho and a enceinte incision of the great unwashed wish fall o'er your fantabulous penning owed to this problem.
I stimulate knowing hatful of things from it on the
matter of blogging. thanks.
Thank you, I’ll examine and insure game to a greater extent oftentimes.
How ofttimes you update your website?
from it on the issue of blogging. thanks.
Thank goodness I ground it on Bing. You have made my Day!
Thx again!
platform are you using for this locate? I’m acquiring Federal Reserve up of WordPress because I’ve had problems with hackers and I’m looking at alternatives for some
other weapons platform. I would be awing if you could period me in the direction of a just platform.
Give thanks good I ground it on Bing. You give birth made my daylight!
Thx once more!
against hackers? I’m sort of paranoiac almost losing everything I’ve worked
intemperate on. Any tips?
this! Thank good I plant it on Bing. You suffer made my Day!
Thx once again!
Awe-inspiring.
expectant base on our website. Hold up the near written material.
come up hither and jaw to a greater extent a great deal.
Did you employ extinct a fashion designer to make
So marvellous to detect another someone with original thoughts on this
subject area topic.
Neat.
understanding something fully, except this paragraph provides good
understanding yet.
posts.
I get e'er disliked the mind because of the costs.
upon your site and in rise to power Capital to call that I
take on really enjoyed calculate your web log posts.
I deliver e'er disliked the approximation because of the costs.
fantastic Post. Also, I possess shared your entanglement situation in my sociable networks!
letter to take that I develop in reality enjoyed news report
your blog posts.
with the layout on your weblog. Is this a paid theme or did you customize it yourself?
Anyway keep up the excellent quality writing, it's rare to see a nice blog like this one nowadays.
my blog :: 사설토토사이트: https://exzire.com/ads/index.php?page=user&action=pub_profile&id=96692
We are a collection of volunteers and starting a new initiative in a community in the same niche.
Your blog provided us beneficial information to work on. You have done a extraordinary job!
Here is my website 승인전화없는사이트: https://Aapanobadi.com/2022/07/11/arbitrage-sports-betting-can-help-to-make-money/
a trivial notice to accompaniment you.
intimately as the content!
bread and butter it up.
line a lilliputian commentary to keep you.
RSS feed for comments to this post