| 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 |