I got it after a friend told me to look at it like this: The Database (Postgres) is the main act in a nightclub. To enter the nightclub, you need a valid clubcart. The bouncer (SQL-Ledger) is asking you for the card (user-access). It does not help to show him a card stating you are member of the practise-room for the band. You still need a valid card (user-rights in SQL).
Same goes for a lot of user access and login I found ;-) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Robin Haeusler Sent: woensdag 18 september 2002 5:12 To: [EMAIL PROTECTED] Subject: [SL] Multi users on one dataset I have created a dataset for one person to use, which has now been set up with accounts and inventory, char of accounts. What I now want to do is to add several other users to access that same dataset. I've added the users, but get following error: SELECT version FROM defaults ERROR: defaults: Permission denied. I've su'ed to postgres and added them as database users with the ability to create database but not add other users. No doubt that I'm missing a step somewhere, but I need to find the somewhere please. ===== Rob Haeusler "work to live, don't live to work" (source unknown) http://mobile.yahoo.com.au - Yahoo! Messenger for SMS - Always be connected to your Messenger Friends ------------------------------------------------------- This SF.NET email is sponsored by: AMD - Your access to the experts on Hammer Technology! Open Source & Linux Developers, register now for the AMD Developer Symposium. Code: EX8664 http://www.developwithamd.com/developerlab ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/ ------------------------------------------------------- This SF.NET email is sponsored by: AMD - Your access to the experts on Hammer Technology! Open Source & Linux Developers, register now for the AMD Developer Symposium. Code: EX8664 http://www.developwithamd.com/developerlab ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
