owner privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: owner privileges

  1. #1
    Join Date
    Feb 2001
    Posts
    1
    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

  2. #2
    Join Date
    Jan 2001
    Posts
    23

    Smile



    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
  •  


Click Here to Expand Forum to Full Width