Secure Backend

[Guest]

Hello,

I have a backend database and several frontends. The database has sensitive
data that only users of one of the frontends are authorized to view and
alter. Is there some way to lock down access to the backend by unathorized
users, but allow the frontend access to the backend to access what is
authorized?

Thanks

 

[Joan Wild]

Hello,

I have a backend database and several frontends. The database has
sensitive data that only users of one of the frontends are authorized
to view and alter.

Somehow I don't think you really mean this. Don't the other frontends need
to at least 'view' the data in the backend?

Is there some way to lock down access to the
backend by unathorized users, but allow the frontend access to the
backend to access what is authorized?

You can remove all permissions from the tables in the backends, and then use
RWOP queries in the frontend for all data interaction.

See www.jmwild.com/RWOP.htm for an explanation.