AnsweredAssumed Answered

Read-only fields in a separation model

Question asked by ChrisPink on Mar 27, 2014
Latest reply on Mar 27, 2014 by philmodjunk


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?