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]

Reply via email to