Schema owner to have resctricted grants
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Schema owner to have resctricted grants

  1. #1
    Join Date
    Mar 2000
    Posts
    18

    Schema owner to have resctricted grants

    I'm toying with a ridiculous possibility:

    Imagine an application is created with a Schema foo (2000+ tables). This user foo owns all tables. Creating them (with system grants), populating them and accessing them. Now, is it possible to revoke a grant on a particular table of this schema (like delete and update) but retain a select grant? Yes, it's not possible to move foo.table to zoo.table. It's important the table remains as foo.table. foo's other grants should not be touched or disturbed.

    Any insights appreciated.

    Thanks,
    BT

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Nope, but you could apply a trigger to the table to raise an error if foo tries to run a delete or an update against it.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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