Clive, I really appreciate the time you've taken to explain these things to me. I think I've got this figured out. I'll give it a whirl tonight and let you know how things turn out.
Thanks Again. Scott On 6/14/05, Clive Menzies <[EMAIL PROTECTED]> wrote: > On (14/06/05 06:47), Redefined Horizons wrote: > > On 6/14/05, Clive Menzies <[EMAIL PROTECTED]> wrote: > > > On (13/06/05 20:41), John Hasler wrote: > > > > I get exactly the same error here. The user I am running pgAccess as > > > > is a > > > > PostgreSQL user. When I run psql I can create the database and then > > > > open > > > > it in pgAccess, but I can't create it in pgAccess. > > > > > > > > Looks like a but. > > > > > > but what? ;) > > > > > > It's not a bug. If you've created a user and you want that user to be > > > able to create databases or users, you need to grant those privileges, > > > initially, as user postgres: > > > > > > CREATE (ALTER) USER <username> PASSWORD <passwd> CREATEDB CREATEUSER; > > > > > How do you sign into pgAccess as the user with the creation > > privileges? I didn't see a place to log on directly in pgAccess. > > That user needs to be created (by user 'postgres') with creation > privileges. > > > Does it use the permissions of whatever current user is logged into > > Debian? > > > Yes. You're running pgaccess as the Debian user logged in which means that > user needs the requisite permissions to create databases and other users > (unless you want to restrict that to user postgres). > > > If I have a user created for Debian, do I simply log in as postgres > > and grant that user the create privileges? > > Yes. Login to the server as postgres create your Debian user with > create privileges and thereafter you don't need to login as postgres. > > > > > Are the "Debian System" users and the PostgreSQL users the same? (For > > example, If I create a new Linux user JoeBlow, is he already a > > PostgreSQL user by default? Or would I have to create a "Postgresql" > > user called JoeBlow also?) > > No. Not unless you specifically create PostgreSQL user profiles for > every system user. > > Regards > > Clive > > -- > www.clivemenzies.co.uk ... > ...strategies for business > > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > >
