-
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.
Thanks,
Calla
-
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.
Nanda.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|