Hi Scott,
One would think that you should be able to accomplish what you are
looking for by changing rows in table -> "tables_priv" in mysql
database. And using "flush privileges" when you done.
mysql> describe tables_priv;
+-------------+---------------------------------------------------------
--------------------------------------+------+-----+-------------------+
-------+
| Field | Type
| Null | Key | Default | Extra |
+-------------+---------------------------------------------------------
--------------------------------------+------+-----+-------------------+
-------+
| Host | char(60)
| | PRI | | |
| Db | char(64)
| | PRI | | |
| User | char(16)
| | PRI | | |
| Table_name | char(64)
| | PRI | | |
| Grantor | char(77)
| | MUL | | |
| Timestamp | timestamp
| YES | | CURRENT_TIMESTAMP | |
| Table_priv |
set('Select','Insert','Update','Delete','Create','Drop','Grant','Referen
ces','Index','Alter') | | | | |
| Column_priv | set('Select','Insert','Update','References')
| | | | |
+-------------+---------------------------------------------------------
--------------------------------------+------+-----+-------------------+
-------+
8 rows in set (0.00 sec)
mysql>
See http://dev.mysql.com/doc/refman/4.1/en/request-access.html
Paragraph begins with words "After determining the database-specific
privileges granted by the db and host table entries"
Regards,
Mikhail Berman
-----Original Message-----
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 4:13 PM
To: MySql
Subject: Table specific privileges (BUMP)
Sorry to push this back out to the list, I am stumped, and the docs are
not leading me to an answer.
One users reply was close, and I had tried it, but it generates an
error, which is also posted in this thread. Thanks everyone, original
message
follows:
MySQL - 4.0.18-standard-log
How do you revoke all privileges from a user for one table in a
database, and still maintain the existing privileges for the other
tables?
For example, I have these tables:
Email
Logbook
Sales_tax
Sessions
Transactions
Users
Orders_A
Orders_B
Lets say I have two users, user_A and user_B Currently, both users have
select, insert, update, and delete on all tables.
I want to totally block user_A from touching Orders_B and totally block
user_B from touching Orders_A
Knowing how to do this the SQL way would help, ultimately, I have to
show a client how to do this in phpMyAdmin, so if anyone knows how to do
it in there, that would be nice as well.
Thanks.
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
