pgaduit - is there a way to audit a role

From: rakeshkumar464 <rakeshkumar464(at)outlook(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pgaduit - is there a way to audit a role
Date: 2017-10-30 22:48:57
Message-ID: 1509403737450-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2017-10-30 22:57:34 Re: query not scaling
Previous Message David G. Johnston 2017-10-30 22:48:35 Make "(composite).function_name" syntax work without search_path changes?