RE: Multi users on one dataset

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]/