Preventing updates to Linked SQL Tables

[Geoff]

We have an app that uses a SQL database. We have created a Linked database
that connects the tables from the SQL database and allows the users to run
queries and reports off these tables. How can we prevent users from updating
the tables?

(Our linked database uses another one of our applications to connect to the
SQL database therefore opening the connection to all of the tables and not
restricting the updating of these tables. They are essentially linking to the
SQL database as the SQL Admin)

Thanks for reading
Geoff

 

[Rick Brandt]

We have an app that uses a SQL database. We have created a Linked
database that connects the tables from the SQL database and allows
the users to run queries and reports off these tables. How can we
prevent users from updating the tables?

(Our linked database uses another one of our applications to connect
to the SQL database therefore opening the connection to all of the
tables and not restricting the updating of these tables. They are
essentially linking to the SQL database as the SQL Admin)

Instead of links create a PassThrough query for each table. These are
automatically read only. Otherwise control it with their permissions on the
server.