Re: Newbie - Are You Sure That's the Correct Pass Phrase?

TC wrote:
pegguru@xxxxxxxxx wrote:

I suspect that the concept is that a user could use separate
passphrases for separate chunks of data.

But that's a guess. We shouldn't design on the basis of guesses!

This clearly illustrates the point that I made to him in my previous
post. We're /guessing/ about his actual requirements, unless & until he
describes what they are.

Thanks again TC:

I'm sensing frustration, and I'm trying to help.

Definitions:

Member - Person who has their information stored
on the database.

User - Person who updates and queries the user
data.

Facility - Club, business, or similar organization
with members and users.

The task:

Store information about club members. This would
be names, addresses, phone numbers, for people and
their family members. In the future I'd like to
be able to store Social

Secure this information while allowing users to
access it.

Some users will access the database on a central
server, others will have the database running on
their laptops.

There is nothing secure about the database. Any
security I write into the program can be
circumvented with a command line SQL query tool.

Threats:

All the usual suspects, you folks know more about
threats than I. One threat will be the theft of a
laptop.

Standards of success:

Provide the members reasonable security. If an
insider gains access to the pass phrase and copies
the data to a CD, and gives that to someone, there
isn't much I can do.

Bad things do happen, bad people do bad things.
When something bad happens to a member because
information entered with this program is
compromised, I'd like to be able to argue that
I provided the tools for a secure system, and
it's not my fault.

Does this describe the system requirements?

What else can I tell you?

I appreciate your advice and your patience.

Thanks
Larry
.

Relevant Pages

  • Re: Run-time error 3033
    ... > only users who can change the value of the property, are members of the ... > Admins group of the workgroup file which was used to secure the ... > database ... > So I suggest that you log on as a member of the Admins group, ...
    (microsoft.public.access.security)
  • Re: Run-time error 3033
    ... only users who can change the value of the property, are members of the ... Admins group of the workgroup file which was used to secure the ... database ... So I suggest that you log on as a member of the Admins group, ...
    (microsoft.public.access.security)
  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: Seen the Survey?
    ... Maybe I've got this whole Scouting thing completely wrong, ... doubtless on virtual Scouting where kids can camp on line, ... I think part of this is looking at getting all members into the ... national Membership database - so that the Association understands it's ...
    (uk.rec.scouting)
  • Re: It was working fine but I read somewhere that for greater normalization of
    ... I have created an access 2007 database for our carers membership. ... I am learning very quickly how access databases function, and need a sample to show me the relationship which will allow me to link spouses, or members residing under the one address. ... but when I try to use it it just shows the spouse in the first spot as the ... These newsgroups are provided by Microsoft for FREE peer to peer support. ...
    (microsoft.public.access.tablesdbdesign)