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]
