Hello,
I am trying to revoke all privileges from a user on a certain table in a
database.
I want the user to continue to have all his/her privileges intact for the
other tables though.
I used the statement REVOKE ALL PRIVILEGES on dbName.tableName from
thisUser;
But that doesn't seem to change
On Mon, 11 Jun 2007, Mahmoud Badreddine wrote:
Hello,
I am trying to revoke all privileges from a user on a certain table in a
database.
I want the user to continue to have all his/her privileges intact for the
other tables though.
I used the statement REVOKE ALL PRIVILEGES on
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
Haneda [EMAIL PROTECTED]
TO:MySql mysql@lists.mysql.com
DATE: Wed, 12 Jul 2006 23:49:41 -0700
SUBJECT: Table specific privileges
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
I keep getting the error:
ERROR 1147: There is no such grant defined for user 'username' on host
'host.example.com' on table 'orders_npfs'
Sean,
As http://dev.mysql.com/doc/refman/5.0/en/revoke.html states,
REVOKE ALL ON `database`.`table` FROM 'user'@'hostname';
MySQL -
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
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
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.
So does this mean my database privs of select, insert, update, and delete
supercede any table