Select, Update, delete , Insert are the Privileges available on a table. If a user creates a table, he is called as owner of the table. He can grant read Privileges(select) to any other user in the database.But what is an Read Only table ? how it differs from Select privilege?
If a table is marked as Read Only by DBA , then the table can never be modified by any user with in the database Including the user who has created this table.
The alter table command can now be used to make a table read-only. This allows the DBA to make a table read-only across the database, including the owner of the table.
The following Example illustrates this