Hi Tom,
> You could look into the information_schema views, or you could write a query using the has_table_privilege()
function.
Could you give an example for such a query? So far I have never heard of this function.
>> Or - another question - how could you possibly copy the rights of a certain user and assign them to another user?
> There's no mechanism for doing that. Usually the recommended solution for "sharing" rights is to assign the rights
toa role created for the
> purpose, and then to grant use of that role to the individual users.
> However this approach requires a bit of foresight ...
... which my predecessors didn't have...
I think I might try the has_table_privilege() function. Thanks!
Annegret