
On Fri, 26 Jan 2001, [koi8-r] ďż˝ďż˝ďż˝ďż˝ďż˝ďż˝ ďż˝. ďż˝ďż˝ďż˝ďż˝ďż˝ďż˝ďż˝ wrote:

>     Good Day, Dear Karel Zak!
> 
> Please, forgive me for my bad english and if i do not right with your 
> day time.

my English is more poor :-) 

 You are right, it is (was?) in TODO and it will implemented - I hope - 
in some next release (may be in 7.2 during ACL overhaul, Peter?). 

Before some time I wrote patch that resolve it for 7.0.2 (anyone -
I forgot his name..)  port it to 7.0.2, my original patch was for 7.0.0. 
May be will possible use it for last stable 7.0.3 too. 

The patch is at:
	 ftp://ftp2.zf.jcu.cz/users/zakkr/pg/7.0.2-user.patch.gz

This patch add to 7.0.2 code NOCREATETABLE and NOLOCKTABLE feature:

CREATE USER username
    [ WITH
     [ SYSID uid ]
     [ PASSWORD 'password' ] ]
    [ CREATEDB   | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
->  [ CREATETABLE | NOCREATETABLE ] [ LOCKTABLE | NOLOCKTABLE ]
    ...etc.

 If CREATETABLE or LOCKTABLE is not specific in CREATE USER command,
as default is set CREATETABLE or LOCKTABLE (true).


 But, don't forget - it's temporarily solution, I hope that some next
release resolve it more systematic. More is in the patche@postgresql.org
archive where was send original patch.

 Because you are not first person that ask me, I re-post (CC:) it to 
hackers@postgresql.org, more admins happy with this :-)
  
				Karel

> I want to ask You about "access control over who can create tables and 
> use locks in PostgreSQL". This message was placed in PostgreSQL site 
> TODO list. But now it was deleted. I so need help about this question, 
> becouse i'll making a site witch will give hosting for our users. 
> And i want to make a PostgreSQL access to their own databases. But there 
> is (how You now) one problem. Anyone user may to connect to the different
> user database and he may to create himself tables.
> I don't like it.



Mon, 29 Jan 2001 23:37:08 +0100 (CET)
Karel Zak <zakkr@zf.jcu.cz>
NOCREATETABLE patch (was: Re: Please, help!(about Postgres))

Can someone remind me what we are going to do with this?


[ Charset ISO-8859-2 unsupported, converting... ]
> 
> On Fri, 26 Jan 2001, [koi8-r] ______ _. _______ wrote:
> 
> >     Good Day, Dear Karel Zak!
> > 
> > Please, forgive me for my bad english and if i do not right with your 
> > day time.
> 
> my English is more poor :-) 
> 
>  You are right, it is (was?) in TODO and it will implemented - I hope - 
> in some next release (may be in 7.2 during ACL overhaul, Peter?). 
> 
> Before some time I wrote patch that resolve it for 7.0.2 (anyone -
> I forgot his name..)  port it to 7.0.2, my original patch was for 7.0.0. 
> May be will possible use it for last stable 7.0.3 too. 
> 
> The patch is at:
> 	 ftp://ftp2.zf.jcu.cz/users/zakkr/pg/7.0.2-user.patch.gz
> 
> This patch add to 7.0.2 code NOCREATETABLE and NOLOCKTABLE feature:
> 
> CREATE USER username
>     [ WITH
>      [ SYSID uid ]
>      [ PASSWORD 'password' ] ]
>     [ CREATEDB   | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
> ->  [ CREATETABLE | NOCREATETABLE ] [ LOCKTABLE | NOLOCKTABLE ]
>     ...etc.
> 
>  If CREATETABLE or LOCKTABLE is not specific in CREATE USER command,
> as default is set CREATETABLE or LOCKTABLE (true).
> 
> 
>  But, don't forget - it's temporarily solution, I hope that some next
> release resolve it more systematic. More is in the patche@postgresql.org
> archive where was send original patch.
> 
>  Because you are not first person that ask me, I re-post (CC:) it to 
> hackers@postgresql.org, more admins happy with this :-)
>   
> 				Karel
> 
> > I want to ask You about "access control over who can create tables and 
> > use locks in PostgreSQL". This message was placed in PostgreSQL site 
> > TODO list. But now it was deleted. I so need help about this question, 
> > becouse i'll making a site witch will give hosting for our users. 
> > And i want to make a PostgreSQL access to their own databases. But there 
> > is (how You now) one problem. Anyone user may to connect to the different
> > user database and he may to create himself tables.
> > I don't like it.
> 
> 
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 7 May 2001 14:48:11 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: NOCREATETABLE patch (was: Re: Please, help!(about Postgres))
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Can someone remind me what we are going to do with this?

I'd like to see some effort put into implementing the SQL-standard
privilege model, rather than adding yet more ad-hoc user properties.
The more of these we make, the more painful it's going to be to meet
the spec later.

Possibly, after we have the SQL semantics we'll still feel that we
need some additional features ... but how about spec first and
extensions afterwards?

			regards, tom lane

Mon, 07 May 2001 17:33:42 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: NOCREATETABLE patch (was: Re: Please, help!(about Postgres)) 

I have added this to the TODO.detail/privileges file.  We can work from
there to decide what needs to be in 7.2.

[ Charset ISO-8859-2 unsupported, converting... ]
> 
> On Fri, 26 Jan 2001, [koi8-r] ______ _. _______ wrote:
> 
> >     Good Day, Dear Karel Zak!
> > 
> > Please, forgive me for my bad english and if i do not right with your 
> > day time.
> 
> my English is more poor :-) 
> 
>  You are right, it is (was?) in TODO and it will implemented - I hope - 
> in some next release (may be in 7.2 during ACL overhaul, Peter?). 
> 
> Before some time I wrote patch that resolve it for 7.0.2 (anyone -
> I forgot his name..)  port it to 7.0.2, my original patch was for 7.0.0. 
> May be will possible use it for last stable 7.0.3 too. 
> 
> The patch is at:
> 	 ftp://ftp2.zf.jcu.cz/users/zakkr/pg/7.0.2-user.patch.gz
> 
> This patch add to 7.0.2 code NOCREATETABLE and NOLOCKTABLE feature:
> 
> CREATE USER username
>     [ WITH
>      [ SYSID uid ]
>      [ PASSWORD 'password' ] ]
>     [ CREATEDB   | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
> ->  [ CREATETABLE | NOCREATETABLE ] [ LOCKTABLE | NOLOCKTABLE ]
>     ...etc.
> 
>  If CREATETABLE or LOCKTABLE is not specific in CREATE USER command,
> as default is set CREATETABLE or LOCKTABLE (true).
> 
> 
>  But, don't forget - it's temporarily solution, I hope that some next
> release resolve it more systematic. More is in the patche@postgresql.org
> archive where was send original patch.
> 
>  Because you are not first person that ask me, I re-post (CC:) it to 
> hackers@postgresql.org, more admins happy with this :-)
>   
> 				Karel
> 
> > I want to ask You about "access control over who can create tables and 
> > use locks in PostgreSQL". This message was placed in PostgreSQL site 
> > TODO list. But now it was deleted. I so need help about this question, 
> > becouse i'll making a site witch will give hosting for our users. 
> > And i want to make a PostgreSQL access to their own databases. But there 
> > is (how You now) one problem. Anyone user may to connect to the different
> > user database and he may to create himself tables.
> > I don't like it.
> 
> 
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 8 May 2001 15:22:08 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: NOCREATETABLE patch (was: Re: Please, help!(about Postgres))
On Mon, May 07, 2001 at 02:48:11PM -0400, Bruce Momjian wrote:
> 
> Can someone remind me what we are going to do with this?
> 
> > This patch add to 7.0.2 code NOCREATETABLE and NOLOCKTABLE feature:


 It's my old patch, it's usable and some people use it for 7.0.x. But 
it's really temporary solution and it was 1 day in official CVS :-) 
We remove it after discussion with Peter E. More correct will implement 
better privilege system.

 A privilege system is *very* important for real multiuser and 
sophisticated systems. For example if you compare PostgreSQL with Oracle, 
the PostgreSQL is really not winner in this part. Peter has some idea
about it and Jan sent something about it too, but I not sure if somebody
works on this and plannig it for some next release (or...? -- will good 
if I not right:-) 

			Karel 

Wed, 9 May 2001 11:12:35 +0200
Karel Zak <zakkr@zf.jcu.cz>
Re: NOCREATETABLE patch (was: Re: Please, help!(about Postgres))
>  It's my old patch, it's usable and some people use it for 7.0.x. But 
> it's really temporary solution and it was 1 day in official CVS :-) 
> We remove it after discussion with Peter E. More correct will implement 
> better privilege system.
> 
>  A privilege system is *very* important for real multiuser and 
> sophisticated systems. For example if you compare PostgreSQL with Oracle, 
> the PostgreSQL is really not winner in this part. Peter has some idea
> about it and Jan sent something about it too, but I not sure if somebody
> works on this and plannig it for some next release (or...? -- will good 
> if I not right:-) 

If we can get something more sophisticated in 7.2, great.  If not, we
may have to apply it later.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 9 May 2001 09:33:20 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: NOCREATETABLE patch (was: Re: Please, help!(about Postgres))