| From: | Ranieri Mazili <ranieri(dot)oliveira(at)terra(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Restricting columns by users |
| Date: | 2007-08-07 13:41:03 |
| Message-ID: | 46B8766F.7050107@terra.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Hello,
I'm looking for a method to restrict columns by users on postgresql,
searching in google I found what I want, but in mysql, below I reproduce
the paragraph that shows what I exactly want:
"MySQL can also restrict access on the table level and even on the
column level. What this means is that a user can have zero privileges on
a database, but can have all privileges on a table in that database.
Alternatively, a user can have zero privileges on a database, restricted
privileges on a table, and all privileges on any particular column on
that table. This is done by inserting records into the TABLE_PRIV table
and the COLUMN_PRIV table."
Exist something like it for postgresql?
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-07 13:59:55 | Re: Removing a schema |
| Previous Message | Filip Rembiałkowski | 2007-08-07 13:23:47 | create table liek view |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Eshom | 2007-08-07 16:54:05 | Adding NOT NULL columns in PostgreSQL 7.4? |
| Previous Message | Michael Glaesemann | 2007-08-06 19:57:27 | Re: [SQL] Using function like where clause |