From: Ranieri Mazili <ranieri.oliveira@terra.com.br>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Restricting columns by users
Date: Tue, 07 Aug 2007 10:41:03 -0300
Message-ID: <46B8766F.7050107@terra.com.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ranieri.oliveira@terra.com.br, pgsql-general@postgresql.org
Subject: Re: Restricting columns by users
In-Reply-To: <46B8766F.7050107@terra.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox