Re: [GENERAL] Audit based on role

2017-08-07 Thread Melvin Davidson
*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 g_supe

[GENERAL] Ora2pg estimation accuracy

2017-08-07 Thread Venkat Ramkrishna
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 he

[GENERAL] the "PgJDBC driver is not an executable" message

2017-08-07 Thread scott ribe
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 tha

[GENERAL] [General] - Ora2PG estimation accuracy

2017-08-07 Thread Venkat Ramkrishna
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 he

Re: [GENERAL] Audit based on role

2017-08-07 Thread Joe Conway
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: https://www.postgresql.org/docs

Re: [GENERAL] Audit based on role

2017-08-07 Thread anand086
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 (pgsql-general@postgr

Re: [GENERAL] Audit based on role

2017-08-07 Thread John R Pierce
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 likehttps://wiki.postgresql.org/w

[GENERAL] Audit based on role

2017-08-07 Thread anand086
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 https://wiki.postgresql.org/wiki/Audi

Re: [GENERAL] Redacting JSONB

2017-08-07 Thread Joshua D. Drake
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

[GENERAL] Redacting JSONB

2017-08-07 Thread Paul Jones
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 yo