Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

SoD table - Excel for Roles conflicts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mralmackay@aol.com - 30 Nov 2007 15:20 GMT
I have a requirement, however after some help on how I should be
looking to approach this or if anyone knows of any examples that
already do this on the web.

I need to check roles within our systems to ensure there's no SoD
conflicts with other roles.

Out of the system I will be able to get a report that will show the
following:

e.g.
UserID    Role
U001    Accounts
U001    Purchasing
U002    Accounts
U003    Purchasing
U003    Invoicing
U004    Accounts
U004    Invoicing
U004    Purchasing

What I then need to be do is build up a table (however I want from a
layout perspective) that would say which roles conflict with each
other.

For example

Role1        Role2
Accounts        Purchasing
Purchasing    Invoicing

I then need to be able to run something that will show any user's
who've 'broken' this rule (e.g. User 1, 3 and 4 in the above example)
and highlight which roles are in conflict.

Is this possible?  Appreciate any help/guidance/examples on this.

Thanks in advance, Al.
Jim Thomlinson - 30 Nov 2007 16:24 GMT
What you are asking for is MUCH better suited to a database such as Access.
While it could be done in XL it will be an up hill battle and at some point
could get darn near impossible.
Signature

HTH...

Jim Thomlinson

> I have a requirement, however after some help on how I should be
> looking to approach this or if anyone knows of any examples that
[quoted text clipped - 34 lines]
>
> Thanks in advance, Al.
mralmackay@aol.com - 30 Nov 2007 18:33 GMT
Thanks Jim.

Will post it on the Access page instead as able to use any tool to do
it as long as I can get it working!.

Cheers, Al.

On 30 Nov, 16:24, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com> wrote:
> What you are asking for is MUCH better suited to a database such as Access.
> While it could be done in XL it will be an up hill battle and at some point
[quoted text clipped - 45 lines]
>
> - Show quoted text -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.