How to grant full access of a schema to a user in Oracle
753236Aug 3 2012 — edited Aug 3 2012For example, in MySql, I login using my account "Andy" to create a database ("create database BookShopping") with tables/views/functions created.
Then I just have to run e.g. "create user Steve (Mike, Lisa, etc) blah-blah; grant all privilege on BookShopping to Steve (Mike, Lisa, etc) blah-blah" to allow all developers in my team to work on this project. Any change made by a developer is shared by whole team. (There are some other non-developer such as QA Rick, he is not allowed to modify database, so I just do "grant select on BookShopping to Rick")
How to do this in Oracle? If I use my account ("Andy") to create tables/views/functions, these object will be under my schema, i.e. with a prefix "Andy". Is my understanding correct here?
So I have to create another user called "BookShopping". After logining as "BookShopping", how to grant full access of this schema to all developers Steve, Mike, etc. including myself "Andy" so that everybody can add new tables/procedures/triggers etc?