Unix Technical Forum

removing create database privileges?

This is a discussion on removing create database privileges? within the pgsql Admins forums, part of the PostgreSQL category; --> I'm probably missing something obvious, but how do I revoke the 'create database' privilege for a user? -- 'Oh, ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 01:22 AM
Dick Davies
 
Posts: n/a
Default removing create database privileges?


I'm probably missing something obvious, but how do I revoke the 'create database'
privilege for a user?

--
'Oh, wait you're serious. Let me laugh even harder.'
-- Bender
Rasputin :: Jack of All Trades - Master of Nuns

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 01:22 AM
Dick Davies
 
Posts: n/a
Default Re: removing create database privileges?

* Tom Lane <tgl@sss.pgh.pa.us> [0231 20:31]:
> Dick Davies <rasputnik@hellooperator.net> writes:
> > I'm probably missing something obvious, but how do I revoke the 'create database'
> > privilege for a user?

>
> See ALTER USER.


Thanks Tom. As usual I found it 15 seconds after posting

--
'Power corrupts. Absolute power - is kind of neat.'
-- John Lehman, Secretary of the Navy, 1981-1987
Rasputin :: Jack of All Trades - Master of Nuns

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-10-2008, 01:22 AM
Tom Lane
 
Posts: n/a
Default Re: removing create database privileges?

Dick Davies <rasputnik@hellooperator.net> writes:
> I'm probably missing something obvious, but how do I revoke the 'create database'
> privilege for a user?


See ALTER USER.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:51 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com