A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Field Privacy



 
 
Thread Tools Display Modes
  #1  
Old November 6th, 2009, 04:06 PM posted to microsoft.public.access.tablesdbdesign
autlew
external usenet poster
 
Posts: 1
Default Field Privacy

I have a database that I need the SSN number for employees as the key. I
want to make it so I can input the SSN number when I add an employee but make
it so others that need to veiw the database can not see the number.
How can I do this?
Thanks
  #2  
Old November 6th, 2009, 04:26 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Field Privacy

It's going to be pretty much work if the SSN must be hidden from all other
users.

Also you won't be able to use it as the primary key field. Note: using a SSN
as the PK is a bad idea anyway. What happens if you have an employee who is
not a US citizen and therefore doesn't have a SSN?

1. You'll need to implement user-level security. Note that Access 2007 accdb
files do not support user-level security.

2. You'll need to create another table with the the PK from the employee
table as the FK and the SSN field.

3. You'll need to create a one-to-one relationship with referential
integrity enabled.

4. You'll need to restrict who can see the data in the SSN table using
user-level security.

OR

You can just hide the employee table and hope that none of your users are
bright enough to figure it out. That could get ugly fast for you if there was
ever an identity theft incident.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"autlew" wrote:

I have a database that I need the SSN number for employees as the key. I
want to make it so I can input the SSN number when I add an employee but make
it so others that need to veiw the database can not see the number.
How can I do this?
Thanks

  #3  
Old November 6th, 2009, 06:32 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Field Privacy

On Fri, 6 Nov 2009 07:06:01 -0800, autlew
wrote:

I have a database that I need the SSN number for employees as the key. I
want to make it so I can input the SSN number when I add an employee but make
it so others that need to veiw the database can not see the number.
How can I do this?
Thanks


What I'd suggest is that you create a surrogate key - it could be an
Autonumber - in the employee table, and make IT the primary key; use it for
linking to the other tables.

Leave the SSN field in the Employee table, with a unique Index, but not make
it the primary key; and of course don't include it in any other tables.

You'll need to prohibit access to table design view, and provide forms which
conceal the SSN field from everyone except you (or those authorized to enter
data), using Access security. See the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Another MVP very aptly described this document as "thirty pages, no filler" -
it's dense, complicated, and can easily be done wrong, so study it CAREFULLY
and follow its instructions to the letter!
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.