| From: | Ferruccio Zamuner <nonsolosoft(at)diff(dot)org> |
|---|---|
| To: | pgsql-sql(at)hub(dot)org |
| Subject: | Permission and users |
| Date: | 2000-10-24 13:49:09 |
| Message-ID: | 200010241349.e9ODn9R80742@tnt.diff.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
PostgreSQL superuser (named A) create two different users:
B: able to create db
C: able to create db
B creates db B_DB
C creates db C_DB
C is able to add tables at C_DB as well as at B_DB.
B is able to add tables at B_DB as well ad at C_DB.
How can I limit C to operate only to C_DB
and
B only to operate on B_DB?
I can modify permission on C_DB to avoid read,modify for B user, but I'm not know how
to exclude B to access to C_DB at all.
Thank you in advance for any reply. \fer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Louis-David Mitterrand | 2000-10-24 13:55:07 | knowing which columns have beend UPDATEd inside a TRIGGER? |
| Previous Message | Craig May | 2000-10-24 13:21:08 | Like Query on BLOB's |