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

Thread: Schema owner to have resctricted grants

  1. #1
    Join Date
    Mar 2000

    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.


  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    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