Thread: Restricting columns by users

Restricting columns by users

From
Ranieri Mazili
Date:
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

Re: [SQL] Restricting columns by users

From
"Andrej Ricnik-Bay"
Date:
On 8/8/07, Ranieri Mazili <ranieri.oliveira@terra.com.br> wrote:

> Exist something like it for postgresql?
I thought that's what views are for ....


> Thanks
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm