dbTalk Databases Forums  

createuser problem

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss createuser problem in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Manu M P
 
Posts: n/a

Default createuser problem - 12-10-2003 , 09:31 PM






Friends

The man page of createuser shows that only superusers can create users with "createuser". How can i make an ordinary user a super user?

Manu


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)


Reply With Quote
  #2  
Old   
christoph.dellavalle@goetheanum.ch
 
Posts: n/a

Default Re: createuser problem - 12-11-2003 , 12:35 AM






Hi

To create a database superuser, use CREATE USER name CREATEUSER
for further details please read Documentation Chapter 4, section 4.2
http://www.postgres.org/docs/7.3/sta...ttributes.html

Chris

Quote:
-----Ursprüngliche Nachricht-----
Von: Manu M P [mailto:manu.mp (AT) maildrop (DOT) m2comsys.com]
Gesendet: Donnerstag, 11. Dezember 2003 04:32
An: pgsql-novice (AT) postgresql (DOT) org
Betreff: [NOVICE] createuser problem


Friends

The man page of createuser shows that only superusers can
create users with "createuser". How can i make an ordinary
user a super user?

Manu


---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo (AT) postgresql (DOT) org

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



Reply With Quote
  #3  
Old   
Oliver Elphick
 
Posts: n/a

Default Re: createuser problem - 12-11-2003 , 03:48 AM



On Thu, 2003-12-11 at 03:31, Manu M P wrote:
Quote:
Friends

The man page of createuser shows that only superusers can create users
with "createuser". How can i make an ordinary user a super user?

ALTER USER username WITH CREATEUSER

(run by an existing superuser)

--
Oliver Elphick Oliver.Elphick (AT) lfix (DOT) co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"The spirit of the Lord GOD is upon me; because the
LORD hath anointed me to preach good tidings unto the
meek; he hath sent me to bind up the brokenhearted, to
proclaim liberty to the captives, and the opening of
the prison to them that are bound."
Isaiah 61:1


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.