This discussion is archived
2 Replies Latest reply: Nov 12, 2012 7:33 AM by NirmalSArri RSS

Giving Full privileges to a user on a given schema

NirmalSArri Newbie
Currently Being Moderated
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?


Thanks

N

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points