Thread: control on table creation

control on table creation

From
R D
Date:
Hi,
In the TODO list is mentioned that in PG-7.1 you will
have "More access control over who can create tables
and use locks".
Does anybody know what concept will be used? Will it
be done via GRANT and REVOKE?

regards,
Rumen

__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/

Re: control on table creation

From
Bruce Momjian
Date:
> Hi,
> In the TODO list is mentioned that in PG-7.1 you will
> have "More access control over who can create tables
> and use locks".
> Does anybody know what concept will be used? Will it
> be done via GRANT and REVOKE?

Good question.  I guess we could create a GRANT DATABASE option to allow
people to create tables in the database.  Not sure where else we could
do it outside of GRANT.

--
  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

Re: control on table creation

From
Peter Eisentraut
Date:
R D writes:

> In the TODO list is mentioned that in PG-7.1 you will have "More
> access control over who can create tables and use locks".

The TODO list is wrong.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Re: control on table creation

From
Bruce Momjian
Date:
> R D writes:
>
> > In the TODO list is mentioned that in PG-7.1 you will have "More
> > access control over who can create tables and use locks".
>
> The TODO list is wrong.

I have it listed as Karel.  I think the patch didn't make it in, for
some reason.  TODO updated.


--
  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