Only insert into tables trough functions

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

Responses

Browse pgsql-sql by date

  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