[GENERAL] pgaduit - is there a way to audit a role - Mailing list pgsql-general

From rakeshkumar464
Subject [GENERAL] pgaduit - is there a way to audit a role
Date
Msg-id 1509403737450-0.post@n3.nabble.com
Whole thread Raw
Responses Re: [GENERAL] pgaduit - is there a way to audit a role  (David Steele <david@pgmasters.net>)
List pgsql-general
Is there a way to audit a group like as follows

alter role db_rw set pgaudit.log = 'read,write,function,ddl'  

and then any user part of db_rw role can be audited automatically.  It does
not seem to work if I connect to the db as rakesh who is part of db_rw role.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: [GENERAL] Make "(composite).function_name" syntax work without search_path changes?
Next
From: Laurenz Albe
Date:
Subject: Re: [GENERAL] query not scaling