pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Restricting columns by users 2+ messages / 2 participants [nested] [flat]
* Restricting columns by users @ 2007-08-07 13:41 Ranieri Mazili <ranieri.oliveira@terra.com.br> 2007-08-07 18:27 ` Re: [SQL] Restricting columns by users Andrej Ricnik-Bay <andrej.groups@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Ranieri Mazili @ 2007-08-07 13:41 UTC (permalink / raw) To: pgsql-general@postgresql.org; 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] Restricting columns by users 2007-08-07 13:41 Restricting columns by users Ranieri Mazili <ranieri.oliveira@terra.com.br> @ 2007-08-07 18:27 ` Andrej Ricnik-Bay <andrej.groups@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Andrej Ricnik-Bay @ 2007-08-07 18:27 UTC (permalink / raw) To: Ranieri Mazili <ranieri.oliveira@terra.com.br>; +Cc: pgsql-general@postgresql.org; pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-08-07 18:27 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-08-07 13:41 Restricting columns by users Ranieri Mazili <ranieri.oliveira@terra.com.br> 2007-08-07 18:27 ` Andrej Ricnik-Bay <andrej.groups@gmail.com>
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