Обсуждение: c (lowercase) privilege

   Hi,

   Does anybody know what's the meaning of the c (lowercase) privilege in
PostgreSQL 8.2 Beta?

bd_test=# SELECT datacl FROM pg_catalog.pg_database WHERE datname='bd_test';
                        datacl
------------------------------------------------------
 {=CTc/user1,user1=CTc/user1}


   In 8.1 documentation is not listed:

                  r -- SELECT ("read")
                  w -- UPDATE ("write")
                  a -- INSERT ("append")
                  d -- DELETE
                  R -- RULE
                  x -- REFERENCES
                  t -- TRIGGER
                  X -- EXECUTE
                  U -- USAGE
                  C -- CREATE
                  T -- TEMPORARY
            arwdRxt -- ALL PRIVILEGES (for tables)
                  * -- grant option for preceding privilege


   Thanks in advance,

   Javier


-----------------
nediam.com.mx/en/

On Fri, 20 Oct 2006, Javier Carlos wrote:

>    Does anybody know what's the meaning of the c (lowercase) privilege in
> PostgreSQL 8.2 Beta?

That should be for CONNECT privilege.

Javier Carlos wrote:
>    Hi,
>
>    Does anybody know what's the meaning of the c (lowercase) privilege in
> PostgreSQL 8.2 Beta?

"connect"



--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Alvaro Herrera wrote:
> Javier Carlos wrote:
> >    Hi,
> >
> >    Does anybody know what's the meaning of the c (lowercase) privilege in
> > PostgreSQL 8.2 Beta?
>
> "connect"

And it is listed in the 8.2 documentation.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +