In order to run that script, you need access to the database (so you run the script from the postgresql command line interface, or from e.g. a PGadmin script window).
Since you do not have access to the database, you will have to do the same manually - easy if your database has few Category Options, but a pain if there are many:
- Go to Maintenance
- Select Category option (listing)
- For each Category option, click the menu (three vertical dots) and then Sharing Settings.
- Click the setting for public access (left of the two icons)
- Select METADATA -> Can Edit and view
- Select DATA -> Can capture and view
- Close, then continue doing the same with all other Category options.
Doing all of them one-by-one in the UI has the same effect as running the above script in the database itself.
After completing, then
- Go to Data Administration, select Maintenance, then tick Clear application cache and then “perform maintenance”
- Run the Browser Cache Cleaner
Then check if your problem has been solved.