8 Replies Latest reply on Apr 22, 2013 11:00 AM by JustinCave

    how to restrict schema from deleting objects from its own schema

    992102
      is it possible to restrict schema from deleting objects from its own schema?
      for example

      scott can create objects but cant delete its own objects like table,view,index

      i am using ORACLE 10.2.0.4

      I know we can do this using triggers but i want to know that -
      Is there any predefined script in oracle which can be used for this purpose?

      Edited by: 989099 on Apr 22, 2013 2:02 AM

      Edited by: 989099 on Apr 22, 2013 2:49 PM