*You can tweak the following query to help you determine if your user is a
member of role/group 'module_dml'.*
*Then you can use it in a trigger function that does the logging.SELECT
g.rolname as group, u.rolname as user, r.admin_option as
admin, g.rolsuper as
Hi All,
I am working on getting an estimation for large scale migration from oracle
to postgresql.
The challenge I am facing is to prove how accurate the cost/man-days
estimation is,given by Ora2pg tool.
Could please help me with the answer if anyone has gone through similar
experience?
Your
Well you know the old saying: "the road to hell is paved with good intentions"!
So an attempt was made to help people who download the JDBC driver and then try
to "run" it:
https://github.com/pgjdbc/pgjdbc/pull/112/files
But here's a fun side effect:
If you add a .jar to an Eclipse project
Hi All,
I am working on getting an estimation for large scale migration from oracle
to postgresql.
The challenge I am facing is to prove how accurate the cost/man-days
estimation is,given by Ora2pg tool.
Could please help me with the answer if anyone has gone through similar
experience?
Your
Is there some way to redact JSONB fields? This is essentially implementing
"row-level" security on JSONB fields. Could possibly be done with a
view or a function. MongoDB and MarkLogic both do this.
PJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On 08/07/2017 12:08 PM, Paul Jones wrote:
Is there some way to redact JSONB fields? This is essentially implementing
"row-level" security on JSONB fields. Could possibly be done with a
view or a function. MongoDB and MarkLogic both do this.
Yeah I imagine you would use a view or function and
Only Insert/Update/Delete sqls are to be audited.
--
View this message in context:
http://www.postgresql-archive.org/Audit-based-on-role-tp5976507p5976509.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list
On 8/7/2017 4:33 PM, anand086 wrote:
We are running Postgres 9.6.3 version and have requirement, where we want to
audit any DML action performed by a user whose has module_dml role granted.
What would be the best way to do that? I was thinking to write something
On 08/07/2017 04:47 PM, anand086 wrote:
> Only Insert/Update/Delete sqls are to be audited.
You could get close to what you want, I think, by setting log_statement
= mod for the users of interest, e.g. by doing:
ALTER USER whomever SET log_statement = mod;
See:
Hi,
I am postgres newbie.
We are running Postgres 9.6.3 version and have requirement, where we want to
audit any DML action performed by a user whose has module_dml role granted.
What would be the best way to do that? I was thinking to write something
like
10 matches
Mail list logo