| From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | kwitten(at)qdt(dot)com |
| Cc: | pghack <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Postgres acl |
| Date: | 1998-01-06 04:36:06 |
| Message-ID: | 34B1B4B6.3948CC8@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> I believe I found a bug. If a user other than the postgres superuser is
> given permission to create databases, then he should be able to destroy
> the databases he creates. Currently he can't, at least in version 6.2.1
> complied for SunOS 5.5. Only the poostgres superuser can delete
> databases. If otherusers try they get the following error message:
>
> "WARN:pg_database: Permission denied.
> destroydb: database destroy failed on tmpdb."
>
> eventhough this user is the database admin for tmpdb as shown in the
> pd_database table.
At the moment, one requires "create users" privilege to destroy your own
database, but only "create databases" privilege to create one. I think
there is something about this on the ToDo list...
- Tom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas G. Lockhart | 1998-01-06 04:43:26 | Re: [HACKERS] My 2c on adjustable blocksizes |
| Previous Message | Integration | 1998-01-06 04:08:10 | My 2c on adjustable blocksizes |