
August 19th, 2000, 06:19 PM
|
|
Junior Member
|
|
Join Date: Jul 2000
Location: Struer, Denmark
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
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?
|