Re: Creating Login

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"Christy" <u18093@uwe> wrote in message news:5ae94b38c82d5@xxxxxx
> Hi,
>
> I am new to AccessVba and was being assigned to complete some security
> features for a few database within limited time.
>
> I will need to create secured login for up to 20 users namely in 4 different
> groups:
>
> User - only read access
> maker - edit, read and delete records only but not able to change any design
> or macro or module
> checker - only able to authorize what the maker have made also no access to
> any design or macro or module
> admin - to have all rights
>
> btw, my users are allowed to have 2 different group at the same time. Thus, I
> am unable to use the build in security features for access 2003.
> My users are able to have maker and checker role at the same time. But some
> may only have one role only.
> The same checker cannot authorize his/her own record as well.
> Those whom are under different user group will see different screens, so for
> people with two groups will be able to choose what kind of group they would
> like to access in upon login in, something like a switchboard. - so the
> usergroup need to be determined upon logging in.
>
> thus, my table will have these fields:
> username (textbox)
> userid (textbox) - unique
> password (textbox)
> maker (yes/no)
> checker(yes/no)
> admin(yes/no)
> user(yes/no)

Access has built in user level security. While it has a steep learning curve
and can be hacked, it is WAY better then anything "home-grown" you will cook up.
Anyone familiar with Access at all will get past your own system with no trouble
at all.

A home-grown system can be useful if all you want to do is nudge cooperative
people in the right direction. It will not provide much of an actual barrier to
people who want to get past it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Creating Login
    ... I am new to AccessVba and was being assigned to complete some security ... am unable to use the build in security features for access 2003. ... My users are able to have maker and checker role at the same time. ...
    (microsoft.public.access.security)
  • Re: Linux Security *Module* Framework (Was: LSM conversion to static interface)
    ... one-true-standard for what that OS security feature set should be. ... So you can wish for the "main OS security features" all you want, ... Same reasons for Posix File Capabilities providing a segmented SUID ... Main OS security features always made tight by the LSM. ...
    (Linux-Kernel)
  • Re: Is 6.0 released?
    ... and others were security features ... Integrity, and a variey of hardening policies, and also support for Access ... CAPP Audit implementation. ...
    (comp.unix.bsd.freebsd.misc)
  • Re: linux box compromised: advice needed
    ... > stapling new features onto it, ... > security review and control. ... And that's why SMTP-Auth and STARTTLS for qmail are third-party patches ...
    (comp.os.linux.security)
  • Re: Looking for a Wireless Video Camera
    ... spending more money does give one more features and ... security system) for any real security use. ... I once had a conversation with a former bank network admin who is also ... doubling the cost of the camera system would not yield a proportional ...
    (alt.internet.wireless)