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, ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| |||
| * 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 |
| ||||
| 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 |