Re: How to find out about user rights

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 to a 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