Save As MySQL is crashing gnucash

[John Ralls]

On Nov 26, 2010, at 10:09 AM, Peter Boosten wrote:

> On 26-11-2010 16:39, John Ralls wrote:
>> 
>> Not quite. Users must be created by a superuser, but can be delegated the create-db privilege, 
>> and gnucash will work best if the userid used to access mysql (or
> postgres) has that
>> privilege.
> 
> Yes, from the lazy-perspective (user friendly?) you are right, but from
> a security point of view this is so NOT done. You never ever want a user
> (in this case even an application user) to have create (or drop)
> privileges (db or table).

That's OK. In that kind of an environment, the initial "save as" just needs to be performed by the DBA, providing her credentials. After that she can, from the appropriate DBA console program (psql or mysql), create the user(s) and change the ownership and privs to whatever the local policies are. That's a bit much for home and most small business users, though.

Regards,
John Ralls