August 19th, 2000, 06:19 PM
I have a database with a certain user that should only be able to access some of the fields in one of the tables.
The user exists in the user-table and I have added him to the db-table and table_priv table with all privileges set to 'N'
The user has then been given select-privileges on some of the fields using the columns_priv table
But now when I log on as this user and write 'use dbname' I get an access denied error.
However if I add select-privileges to the user in the db-table, then it works - but then he will be able to select anything from the table, which he was not supposed to do...
How can I grant the user access to 'use' the database without giving him select-options on more than a few fields?