Read-only fields in a separation model
I have a database that makes bookings. A Booking is an entity that links 3 tables, Customer, Workshop and Payments (1 to 1, 1 to 1, one to many).
The database is based on a separation model. The scripts are all in the GUI database.
I have a script that creates bookings. A Booking, once it has a Customer ID and a Workshop ID will never have that information changed (with dependent fields, eg Date).
So how do i create a set of privileges on the data in the data database and link that to the user logged in the GUI database?