CODEWITHSUNDEEP
oracle-databaseoracle11g
Mohan P
Mohan P

Reputation: 399

Disable read as well as write in an existing table

We have a table already existing in oracle 11g database which allows read as well as write operations. I want to block both read as well as write operations to the table. Can you please help?

Upvotes: 1

Views: 181

Answers (1)

DCookie
DCookie

Reputation: 43533

Use the REVOKE command to take permissions away from other users. You cannot revoke privileges from the table owner, however.

You could also export the table and then drop it. Nobody can read it then :-)

Upvotes: 3

Related Questions