Schlagwort-Archive: permissions

How to protect a Firebird table against direct writing?

In Firebird it is possible to insert/update data in a table even if the user did not have direct write access to this table. One way is to insert/update data via a stored procedure. In this case the user connected to the database has only execute permissions to the stored procedure. The stored procedure has the necessary insert/update permissions to the table. Weiterlesen