Re: How to set table-specific privileges

2007-06-11 Thread Gordan Bobic
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

How to set table-specific privileges

2007-06-11 Thread Mahmoud Badreddine
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