2 Replies Latest reply: Nov 12, 2012 9:33 AM by NirmalSArri RSS

    Giving Full privileges to a user on a given schema

      Hi there,
      Here is something I want to achieve in Oracle 10g/11g:

      I have a schema APP_RW, I need to create a user JOHN and need to grant full access on the schema APP_RW, that means JOHN can create/drop objects in schema APP_RW, with insert/update/delete/execute any object with APP_RW.

      That said, I know I can grant "CREATE ANY" Privilege to JOHN, but that will allow him to create objects in any schema. I want to restrict JOHN to only APP_RW.

      Is there a way in oracle to do this?