column level, uid based authorization to update columns

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема column level, uid based authorization to update columns
Дата
Msg-id 482E80323A35A54498B8B70FF2B8798004188B2064@azsmsx504.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: column level, uid based authorization to update columns  (Ries van Twisk <pg@rvt.dds.nl>)
Re: column level, uid based authorization to update columns  (David Fetter <david@fetter.org>)
Re: column level, uid based authorization to update columns  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general

In linux, given the linux based uid of the user, how might someone implement column level update restrictions on a uid basis?  For example...

 

create table foo (strcol varchar(256), intcol integer);

 

Now, I want linux processes runing under uid “joesmith” to be able to update strcol but not intcol.  Some other user could update intcol but not strcol.  Others could update both, others neither.  I’m also willing to give you a table that maps all uids to the columns they can update, something you could ref in a constraint or update trigger or something.   So that might be something like...

 

            create table foo_auth (uid varchar(256), cols text[]);

            insert into foo_auth (uid,cols) values (‘joesmith’,’{‘strcol’}’);

insert into foo_auth (uid,cols) values (‘jillbrown’,’{‘intcol’}’);

            insert into foo_auth (uid,cols) values (‘thedba’,’{‘strcol’,’intcol’}’);

 

Thanks in Advance !

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Edoardo Panfili
Дата:
Сообщение: add a value to an ENUM type
Следующее
От: Ries van Twisk
Дата:
Сообщение: Re: column level, uid based authorization to update columns