pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
removing create database privileges?
3+ messages / 2 participants
[nested] [flat]

* removing create database privileges?
@ 2005-02-10 20:13 Dick Davies <rasputnik@hellooperator.net>
  2005-02-10 20:31 ` Re: removing create database privileges? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Dick Davies @ 2005-02-10 20:13 UTC (permalink / raw)
  To: pgsql-admin


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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: removing create database privileges?
  2005-02-10 20:13 removing create database privileges? Dick Davies <rasputnik@hellooperator.net>
@ 2005-02-10 20:31 ` Tom Lane <tgl@sss.pgh.pa.us>
  2005-02-10 20:35   ` Re: removing create database privileges? Dick Davies <rasputnik@hellooperator.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2005-02-10 20:31 UTC (permalink / raw)
  To: Dick Davies <rasputnik@hellooperator.net>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: removing create database privileges?
  2005-02-10 20:13 removing create database privileges? Dick Davies <rasputnik@hellooperator.net>
  2005-02-10 20:31 ` Re: removing create database privileges? Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-02-10 20:35   ` Dick Davies <rasputnik@hellooperator.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Dick Davies @ 2005-02-10 20:35 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

* 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-02-10 20:35 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-10 20:13 removing create database privileges? Dick Davies <rasputnik@hellooperator.net>
2005-02-10 20:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-02-10 20:35   ` Dick Davies <rasputnik@hellooperator.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox