SEO

#1 (**permalink**) 02-28-2008, 06:35 AM

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 anything.
The message always gives "Query 0K, 0 rows affected..."
What could I be missing.
Thank you.

--

http://www.spreadfirefox.com/

#2 (**permalink**) 02-28-2008, 06:35 AM

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 dbName.tableName from
> thisUser";
>
> But that doesn't seem to change anything.
> The message always gives "Query 0K, 0 rows affected..."
> What could I be missing.

I seem to remember that this always says 0 rows affected.
To make sure the privilege changes stick, follow that up with:

mysql> FLUSH PRIVILEGES;

That should do the trick.

Gordan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to set table-specific privileges