> That the user can connect to other databases, indicates that you have
> created that user as a superuser
Works perfectly for a simple mortal here. Moreof, a user can create his
tables:
copl=# select * from pg_shadow where usename = 'cdl_user';
usename | cdl_user
usesysid | 307
usecreatedb | f
usetrace | f
usesuper | f
usecatupd | f
passwd |
valuntil |
copl=# \c copl cdl_user
You are now connected to database copl as user cdl_user.
copl=> \dt
Name | copl_global
Type | table
Owner | root
------+------------
Name | ours_hints
Type | table
Owner | root
------+------------
Name | ours_refs
Type | table
Owner | root
------+------------
Name | ours_users
Type | table
Owner | root
copl=> select * from copl_global;
ERROR: copl_global: Permission denied.
copl=> create table test( id int4 );
CREATE
copl=> drop table test;
DROP
copl=> \c mailarch cdl_user
You are now connected to database mailarch as user cdl_user.
mailarch=> \dt
Name | messages
Type | table
Owner | root
mailarch=> select * from messages;
ERROR: messages: Permission denied.
mailarch=> create table test( id int4 );
CREATE
mailarch=> drop table test;
DROP
Am I missing something?
TIA
Ed
---
Well I tried to be meek
And I have tried to be mild
But I spat like a woman
And I sulked like a child
I have lived behind the walls
That have made me alone
Striven for peace
Which I never have known
Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)