Mailing List Archive


Back to the month index Back to the list index
Charles Reese (reese@chem.duke.edu)
Sat, 25 Jan 1997 17:30:06 -0500 

Message-Id: <1.5.4.32.19970125223006.007158a4@chem.duke.edu>
Date: Sat, 25 Jan 1997 17:30:06 -0500
From: Charles Reese <reese@chem.duke.edu>
Subject: Re: [mSQL] [mSQL:] Databse with individual-row access...

I don't think this is possible if what you are saying is that you want to
grant access on a per table or per record basis. You will need to create an
identifier for each record in each table that you want to control access to.
Have your access script login your users and give them access according to
the identifier. For example you could have a CV table and store their login
name as one of the fields then have a perl script check their user name and
compare it against that field. If you are doing it by WWW you can do the
same thing with PHP and a little login php script.

Cheers
Charlie Reese

At 07:16 PM 1/25/97 +0100, you wrote:
>Dear mSQLers,
>
>I would like to create a remotely-updatable database where several
>individuals are each responsible of updating their own part of the
>database (actually, thir own curriculum vitae)
>
>Is it possible to create such a database where every person has rights to
>modify a part of the database while everybody is able to read everything.
>Is it possible to do this with mSQL and standard w3-msql?
>
>If it cannot be done with these tools, could you suggest a candidate
>(hopefully free) DBMS and companion tools?
>
>
>Thanks *a real lot* in advance.
>
>
>Marco Bravi
>
>--------------------------------------------------------
> PLEASE SEND REPLY MAIL TO:
>
> Marco.Bravi@impchim.ing.uniroma1.it
>
> --- T H A N K S ---
>
>Marco Bravi, Dip. Ing. Chimica, Univ. Roma "La Sapienza"
>v. Eudossiana, 18; I - 00184 Roma, Italy
>tel. (39) (6) 4458-5780; fax. (39) (6) 4827453
>
>
>--------------------------------------------------------------------------
>To remove yourself from the Mini SQL mailing list send a message containing
>"unsubscribe" to >"unsubscribe" to msql-list-request@bunyip.com. Send a message containing
>"info msql-list" to majordomo@bunyip.com for info on monthly archives of
>the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!
>
>

------------------------------------------------------
Charles E. Reese * Senior Research Associate *
Chemistry Dept. * *
Duke University * Consulting services: *
Durham, NC 27710 * Chromatography *
919-660-1585 * Chemometrics *
919-544-7217 * Isotachophoresis *
                        * WWW site development *
reese@chem.duke.edu * *
------------------------------------------------------

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!