Re: Is there some way to fake row priledges?

[Chris Stubben]

Hi,

You should be able to list columns after privileges like this...

grant delete, update (columna, columnb) on dbname.table to 'user';


Also, if you really want row level privileges, you probably need to code this into a web interface (only webuser can update the table, and will only allow changes to rows where the login column matches a user's login name).

Or you can use a separate table for each user and then use UNIONS to collect rows from all tables. Or you may be able to use one table and create updatable views in 5.0 (one for each login user). Both with be difficult to manage...


Chris