• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

How to sketch user rights indicated in the database for a design plan documentation?

Hi there;

How to sketch user rights indicated in the database for a design plan documentation? I am using Visio 2007

Kind regards.
0
jazzIIIlove
Asked:
jazzIIIlove
  • 6
  • 5
6 Solutions
 
mcs0506Commented:
Hi,
I also answered  this question in an other question check out the following link
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27423028.html

Regards,

Dani
0
 
jazzIIIloveAuthor Commented:
Hi there,

Thanks for the fast reply.

But where are the roles, how can i associate the roles to your answer in that question?
0
 
mcs0506Commented:
roles are equivalent to Functionality in schema
0
The Firewall Audit Checklist

Preparing for a firewall audit today is almost impossible.
AlgoSec, together with some of the largest global organizations and auditors, has created a checklist to follow when preparing for your firewall audit. Simplify risk mitigation while staying compliant all of the time!

 
jazzIIIloveAuthor Commented:
ok but what is the cardinality between them?

who is One-Many etc.
0
 
jazzIIIloveAuthor Commented:
and I have several user types, as admin, manager. So, does it reflect usergroup table?

I am a little confused.

Regards.
0
 
mcs0506Commented:
Hi
Let me Explain

Users (contains User Information with UserId as PK)
Roles (Contains names of all possible roles with RoleId asPK )
RolePermission  (Contains association of Role with user that actually have permission for specific RoleId or me can say that it contains 2 FK's  as UserId and RoleId)

The relation for these FKs(foreign keys) are
One to Many for   User => RolePermission
One to Many  for  Roles => RolePermission

If you wany to add UserGroup then Add UserId in UserGroup Table And UserGroupId is referred to RolePermission table.

Regards,

Dani
0
 
mcs0506Commented:
Here is some more details

Users (contains User Information with UserId as PK)
Groups (contains Group Names With GroupId)
UserGroup (Contains association of user and group with FKs UserId and GroupId)
Roles (Contains names of all possible roles with RoleId asPK )
RolePermission  (Contains association of Role with Group that actually have permission for specific group according to that role, or I can say that it contains 2 FK's  as UserId and GroupId)
0
 
jazzIIIloveAuthor Commented:
Could you examplify with a very simple scenario or just populate those tables with a one row so that I can understand the underlying idea?

E.g. manager, admin etc

Regards.
0
 
mcs0506Commented:
Here is sample file hopefully this may helpful to you


Dani Book1.xlsx
0
 
jazzIIIloveAuthor Commented:
ok, i got the confusion; as isn't manager is a role, but it's a groupname in your system. Am I wrong?

Kind regards.
0
 
mcs0506Commented:
yes it is role is something like action for that groups
0

Featured Post

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now