It is possible using the columns_priv table in the mysql database. Check
out http://www.mysql.com/doc/P/r/Privilege_system.html for more information.
Good Luck,
David Price
-----Original Message-----
From: Jonas Arvidsson [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 3:09 AM
To: [EMAIL PROTECTED]
Subject: How to grant user access to specific column
Hi
This is my first question to this group.
Is there anyway to grant access for all users to a table but two columns in
that table should be readonly, and
if username is something else it should have access to those two columns
with read and write and change.
Regards
Jonas Arvidsson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
