From: | Alvin Díaz <alvin(dot)rd(at)live(dot)com> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Only insert into tables trough functions |
Date: | 2017-10-14 13:36:41 |
Message-ID: | BN6PR17MB1601E555AA4B8F01C03B652CE7490@BN6PR17MB1601.namprd17.prod.outlook.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi community.
I’m working in a project as architect so I’m focused in control as much as possible from the database in other words business logic is in the DB so I’m trying to find a way to prevent developers can insert directly on tables instead o directs insert against data table the should be force to use the prebuilt functions.
If I implement this scheme I make sure that developers follow business logic then I want to listen some suggestions because I was thinking in create functions whit security definer with a user with permission to write in the tables then create a user for developers allowing then just read all tables and execute the functions.
Best regards.
Alvin Diaz.
Sent from my iPhone
From | Date | Subject | |
---|---|---|---|
Next Message | ROS Didier | 2017-10-16 13:38:23 | How to index encrypted colums ? |
Previous Message | ROS Didier | 2017-10-11 07:49:25 | Re: ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 - fixed |