How do I lock down a table from delete and truncate statements when the application logs the users in as the table owner.
I have granted only insert, update and select privileges but as the owner, the users still have the ability to drop tables.
If you are the table owner, oracle assumes that you have the right to drop/delete/truncate tables. To avoid this you can implement a the recommended THREE SCHEMA/TWO SCHEMA architecture, where in you'll be creating the synonyms for the table and the privileges which you had given now will be enough to serve the purpose.
Reply With Quote
Bookmarks