February 3, 2006 at 1:34 am
Hi folks
I am developing a n-tier distributed app that has a SQL Server back end and
will be deployed on an intranet.
There will be a number of Users.
There is a table called Clients and a second table called
ClientConfidentialDetails. There is a relationship between the two tables (1
to many). The ClientConfidentialDetails table will have confidential info
regarding the Client (a person) that is by default only accessible to the
User or group of Users in the same office that have made entries in the
ClientConfidentialDetails table.
However, there is a requirement that a User in say Office A can authorise
full access to info in the ClientConfidentialDetails table for either a particular User
or group of Users in another office for those records in that table that were
entered by the first office.
If somebody could give me a few clues about this I would appreciate it.
Kind regards
Ross Petersen
February 3, 2006 at 7:20 am
Create a view of the table that enforces your access rules.
If you have your DDL....I could help you further.
HTH
Mathew J Kulangara
sqladventures.blogspot.com
February 3, 2006 at 1:25 pm
Thanks Mathew
By DDL do you mean the database diagram?
If so, I will post it shortly.
Kind regards
Ross
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply