This issue has been resolved, but I was wondering if the solution below
would work.
Is it possible to create a user that belongs to the database owner with all
the privileges required by the user group and then this "user" GRANT(s) ALL
to individual users? When the user leaves you can revoke that user's
privileges.
Enrique Wintergerst
> > 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
> > >
> > >
> > >
> >
>
