From time to time you may wish to stop an individual or group of users the ability to add / update or delete records in Ostendo, whilst still giving them access to specific functions within Ostendo.
In this example we will prevent a user 'GENERAL' from adding / updating and deleting Items from the Items screen.
1) Create a Screen Data Script called in this case 'No Update on ItemMaster'
2) Copy this code into this script:
begin
if (currentuser = 'GENERAL') then
begin
showmessage('You cannot update data from this screen');
abort;
end;
end.
3) Go to File->Scripting Configuration->Screen Data Scripts and specify the following entries:
- Screen = Items
- Table Name = ITEMMASTER
- SQL Type = Insert
- Script Name = No Update on ItemMaster
Repeat this for SQL Types Update and Delete.
4 ) Log out of Ostendo and log in as the GENERAL user name. Now if you attempt to change anything on the Items screen you will receive a message preventing you from saving the record.
Related Articles
Archiving Historical Journal Records
When we post to Accounting products like MYOB AR Live, Xero, QBO and Sage Evolution, we post from 4 tables in Ostendo. JOURNALHEADER (these records will be posted as General Ledger Journals in the Accounting Software) JOURNALLINES (each journal may ...
25/11/2021 - Archiving Historical Journal Records
Archiving Historical Journal Records When we post to Accounting products like MYOB AR Live, Xero, QBO and Sage Evolution, we post from 4 tables in Ostendo. JOURNALHEADER (these records will be posted as General Ledger Journals in the Accounting ...
19/11/2025 - Updating a Firebird 2.5 Database to Firebird 5
Updating a Firebird 2.5 Database to Firebird 5 The Importance Of The Current Testing Phase: Partner Testing of Update 243 has been progressing well, with a number of reported items already resolved. Our expectation is that all Partners have now ...
Firebird Restart to improve performance and remove External Users
Firebird Stop / Start process Large Ostendo sites running 20+ users should stop and re-start Firebird on a regular basis to ensure performance is maintained. The major issue to automating this process in the past has been the worry that users may ...
Copying Users From Another Ostendo Database
Use these std scripts to copy all users from one Ostendo database to another. Create a std type export script in the originating database, then create a std type script in the other database to import these users