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.
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.
Click Here to Expand Forum to Full Width