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 dbNa
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
> 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 tabl
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
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 r
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 - 4.0.18-sta
age --
FROM: Scott Haneda <[EMAIL PROTECTED]>
TO:MySql
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
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
