Albert, please send me your address.
Dave
[EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Albert Berry
> Sent: Wednesday, June 06, 2001 3:01 PM
> To: [EMAIL PROTECTED]
> Subject: Re: GRANT to groups
>
>
> Been there, done that, e-mail me privately for a copy of my code.
>
> ----- Original Message -----
> From: David Ebert <[EMAIL PROTECTED]>
> To: RBase Mailing List <[EMAIL PROTECTED]>
> Sent: Wednesday, June 06, 2001 10:57 AM
> Subject: GRANT to groups
>
>
> > I'd like to grant options based on classes of employee (analagous to
> Netware
> > Groups) instead of individuals in a high-turnover organization.
> >
> > I'm considering using a table to track users by name (full),
> username, and
> > password. In the same table I could use a group code that would FK to a
> > Groups table.
> >
> > In the groups table I want to have a user name I can set as a
> variable for
> > the USER password (SET USER .vuserid .vpassword). Further, I
> could check
> > the entered userid against the system variable from the NOS for user
> (i.e.,
> > Nuser) to see if who you said you were at login is who you are trying to
> be
> > in the database.
> >
> > My reasoning is based on two considerations:
> > 1. I need to restrict insert and edit to a given class of employee for
> ALL
> > tables while letting all others have SELECT rights,
> >
> > 2. I need to provide ensurance under HIPAA (Health Insurance
> Privacy and
> > ortability Act) that only authorized personnel have access not
> only to the
> > data but to the database functions.
> >
> > I'm hoping to spare myself another level of administration.
> >
> > Has anyone tried this,and if so, does/should it work?
> >
> > tia
> >
> > Dave
> >
> >
> >
>
