xTuple fine - psadmin3 not
Mepis Linux (Debian) installation - all seems well.
xTuple client functioning fine, reads, writes, etc.
But in pgadmin3, when I try to modify database, I get a "no privileges" message.
I try GRANTing everything, SQL window says transaction OK but still cannot update
any tables. Arrrgh...
This does not happen with the same database in Windows.
What am I missing?
Tue, 07/20/2010 - 10:14
#2
Thanks for that. I'll dig
Thanks for that. I'll dig some more.
Mystery for me is the difference in behavior between Windows and Linux.
I do the same install, and the same psql database load on each platform.
xTuple performance is the same.
pgadmin behavior is different.
Is there a difference in the installer? Or the default pgadmin behavior?
Or are Windows permissions not as tight?
Hi--
Depending on what you are trying to accomplish, it could be some of the xTuple security measures getting in your way. If you are trying to modify data inside of the xTuple tables from a PostgreSQL role that is not also an xTuple user with application level permissions, this will cause you some problems. The xTuple application enforces application rights (at least to some degree) even for common database DML operations executed from outside of the application. It does this through triggers on the tables that check to see if the executing user has the appropriate application level permissions for the operation. So if you're trying to insert a record into an application table and don't have the corresponding application permission on the PostgreSQL role, it will stop you.
Other than that, we'd need greater details on what specifically you're trying to accomplish.
Regards,
Steven C. Buttgereit
www.musesystems.com