Multiple users in mysql

Article View: borland.public.cppbuilder.database.multi-tier

Article #430

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#430

From: Reynold M. de Guzman
Date: Wed, 10 Oct 2001 14:46

24 lines
1454 bytes

Hello,

Does anyone know how to restrict record access in a table depending on
the admin name.

For example there is table called "scratchpad" and there is a field
called "admin".

I want everyone with a name in the admin tab to be able to insert a
record but I want the users to only be able to edit or delete records
with their name in the "admin" field.

Can this be done or should I make a separate table for each user?
There may be thousands of users and each user would then have about 5
tables.

Thanks for any help.

Reynold


---
Reynold M. de Guzman
deguzman@offworldcolony.com

Technical Details

Message-ID: <3bc45f29.26884224@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!newspump.sol.net!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,6029300822978c9b,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-10-10 08:06:53 PST
From: deguzman@offworldcolony.com (Reynold M. de Guzman)
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Multiple users in mysql
Date: Wed, 10 Oct 2001 14:46:40 GMT
Message-ID: <3bc45f29.26884224@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.5/32.452
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 63.253.122.34
X-Trace: dnews 1002725243 63.253.122.34 (10 Oct 2001 07:47:23 -0700)
Lines: 24
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!newspump.sol.net!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews