Table security

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am looking for simple security on a single table in database. This table
needs to be accessed only by a specific user (picked up from windows login)
and no one else. What is the way to achieve this?

Thanks

Regards
 
John said:
Hi

I am looking for simple security on a single table in database. This
table needs to be accessed only by a specific user (picked up from
windows login) and no one else. What is the way to achieve this?

Thanks

Regards
Click to expand...

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.
 
Back
Top