user7047382 wrote:with Oracle EVERYTHING is prohibited, except that which is explicitly GRANTed.
I am having the following issue: on CUSTOMERS table I implemented a policy that prevents specific users to delete records that have REPORT_DATE (this is a DATE column) older than 2 months. Works fine.
However... I realized that these users can drop a partition from this table (the table in partitioned BY RANGE) so the policy I implemented is useless.
My question: is there any way to prevent specific users to drop a partition?
All partitions in CUSTOMERS table are associated with a unique REPORT_DATE therefore I would like to prevent deletions of a partition that has a related REPORT_DATE older than two months...
user7047382 wrote:If schema own can CREATE any object, Oracle implicitly GRANT DROP on same object.
Thank you for your suggestion sb92075. I have little experience with Oracle. How can I remove a GRANT for a specific login user? There is only one schema in the database.