Thomas Dean wrote:
>If I understand your question correctly, createuser will do this.
>
>'man createuser'
>...
> -D Does not allow the user to create databases.
This does not affect the ability to create tables; only databases:
junk=> alter user dan nocreatedb;
ALTER USER
junk=> \connect - dan
connecting as new user: dan
junk=> create table yyyy (id integer);
CREATE
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Jesus said unto her, I am the resurrection, and the
life; he that believeth in me, though he were dead,
yet shall he live; And whosoever liveth and believeth
in me shall never die. John 11:25,26
