Technical resoource availability

Question

I want to create a read-only database for each record only once appending and never changed, including transactions log resource. All to guarantee integrity for third parties with authorized access. Can I do that on Azure?

Answer 1

But you just need to create a normal database and give users only INSERT and SELECT permissions on all tables (the whole database)

GRANT INSERT, SELECT  TO SomeUser

or you can specify on which tables.

GRANT INSERT ON YourTable TO SomeUser

You can also deny all users to delete/update data on all tables

REVOKE UPDATE, DELETE TO abc;