Re: Anyone can create tables! - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: Anyone can create tables!
Date
Msg-id 3.0.5.32.20010311215124.00fe3100@192.228.128.13
Whole thread Raw
In response to Re: Anyone can create tables!  (Dan McGrath <dmcgrath19@home.com>)
Responses Re: Anyone can create tables!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
At 10:12 PM 3/10/01 -0500, Dan McGrath wrote:
>Thanks Tom. Actually its kinda holding me off really bad. I would like to
>switch to mysql, but I still feel confident in pgsql to stay. One fellow on
>irc I talked with mentioned the possibilty of creating a trigger on the
>internal pgsql tables to restrict adding or creating anything. I just think
>its very bad for me to consider opening my db to the world with that kind of
>access open to the public. Would be like hotmail allowing unlimited email
>size. You get my idea anyways Im sure.

I doubt that I would ever recommend opening any RDBMS to the world.

There is a very high chance that even if controls are put in, there will be
ways around it.

It's as bad as giving a unix/cmd shell to the world.

Aren't there other ways to do what you want without giving the world access
to your database?

Maybe each user could have their own postgresql engine running on their own
server (real or virtual).

Cheerio,
Link.


pgsql-general by date:

Previous
From: Dan McGrath
Date:
Subject: Re: Anyone can create tables!
Next
From: newsreader@mediaone.net
Date:
Subject: big int