CODEWITHSUNDEEP
sqloracle-database
napster
napster

Reputation: 193

How to prevent write access to a Oracle table

We have a table in oracle, that should store all application properties in key, value columns. This table is a constant table(meaning no data to be written while the application is alive) So how do we prevent write access to this table for all DB users except Data base admin.

Upvotes: 1

Views: 502

Answers (1)

user272735
user272735

Reputation: 10648

Reading the fine manual: Placing a Table in Read-Only Mode.

You can place a table in read-only mode with the ALTER TABLE...READ ONLY statement, and return it to read/write mode with the ALTER TABLE...READ WRITE statement. An example of a table for which read-only mode makes sense is a configuration table. If your application contains configuration tables that are not modified after installation and that must not be modified by users, your application installation scripts can place these tables in read-only mode.

Upvotes: 5

Related Questions