relacl parsing method?
От | Josip Rodin |
---|---|
Тема | relacl parsing method? |
Дата | |
Msg-id | 20100216112229.GA27842@orion.carnet.hr обсуждение исходный текст |
Ответы |
Re: relacl parsing method?
Re: relacl parsing method? Re: relacl parsing method? |
Список | pgsql-general |
Hi, I want to find out whether a user has a select privilege on a particular database. This is what I see when it does: # select relacl from pg_class where relname = 'mydbtable'; relacl -------------------------------------------------------------------------- {mydbname=arwdxt/mydbname,mydbuser=r/mydbname} (1 row) Is this the best way to parse that easily from within PostgreSQL: # select 1 from pg_class where relname = 'mydbtable' and relacl ~ 'mydbuser=r/mydbname'; ?column? ---------- 1 (1 row) # select 1 from pg_class where relname = 'mydbtable' and relacl ~ 'mydbuser=w/mydbname'; ?column? ---------- (0 rows) Where is this documented? I tried searching for 'relacl' and 'aclitem' in the docs, but didn't come up with much. I did find a Perl module at http://search.cpan.org/~dwheeler/Pg-Priv-0.10/ that seems to extract relacl and parse it on its own, which sounds like a kludge. (Please Cc: replies, I'm not subscribed. TIA.) -- 2. That which causes joy or happiness.
В списке pgsql-general по дате отправления: