Обсуждение: CREATE TABLE (allow/deny)

Поиск
Список
Период
Сортировка

CREATE TABLE (allow/deny)

От
R D
Дата:
Hi,

I'have been waiting for a long time for control on who
can and who can not create tables. I'm plannig to
migrate all my DBs from MySQL to PostgreSQL (I have
already done this where possible) but it's inpossibe
now since now it's inpossible to deny table creation
to some users. I hoped that 7.1 will fix the
problem...

Now few of them are running PG and few MySQL for that
reason.

Control on table creation is so inporatnt and I can
not understand why it has not been done yet!

So can anybody tell me will it be inplemented in the
foreseeable future? Probably Pg7.2?

Rumen




__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

Re: CREATE TABLE (allow/deny)

От
Jesus Sandoval
Дата:
I am waiting for this feature too, I was looking in the todo list and
found privileges in the url
http://candle.pha.pa.us/cgi-bin/pgtodo?privileges, it mentions a patch
for creating users without createtable permission, maybe it is not what
we are expecting, they say it is a temporary solution.
I have not tried it yet.

Regards
Jesus Sandoval

R D wrote:

> Hi,
>
> I'have been waiting for a long time for control on who
> can and who can not create tables. I'm plannig to
> migrate all my DBs from MySQL to PostgreSQL (I have
> already done this where possible) but it's inpossibe
> now since now it's inpossible to deny table creation
> to some users. I hoped that 7.1 will fix the
> problem...
>
> Now few of them are running PG and few MySQL for that
> reason.
>
> Control on table creation is so inporatnt and I can
> not understand why it has not been done yet!
>
> So can anybody tell me will it be inplemented in the
> foreseeable future? Probably Pg7.2?
>
> Rumen
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)