No.

You can filter results based on the row level security policy
Row-Level Security
https://docs.intersystems.com/iris20252/csp/docbook/Doc.View.cls?KEY=GOB...

You can also grant access to specific columns in tables to particular roles, and then grant these roles to a particular user
https://docs.intersystems.com/iris20252/csp/docbook/Doc.View.cls?KEY=RSQ...

Hi Theo. What disadvantages does Embedded SQL have?

Hi Dean.

Please check if it works via http, not https. I wonder if the certificate configuration is the issue

In IIS -- create /api web-application if it does not exist, and add handler mapping for "*" files to CSPms module

Also see
https://docs.intersystems.com/iris20251/csp/docbook/DocBook.UI.Page.cls?...