On 08/02/13 10:56, Melvin Call wrote: > > If I may pigtail another related question, what is the procedure for > allowing another user access to that schema?
Heh. You almost have the words already: grant usage on schema hrschema to hr_user;
Too easy! Thanks for the help. That'll teach me to try to learn something new in the middle of development crunch time! And many thanks for the link as well. This will help a great deal.
This will allow them to see the objects in the schema. It does nothing to allow them to access the objects themselves, so you'll still need to grant the appropriate privileges on the objects within the schema. You can use default privileges if you don't wish to grant them at creation time. See the docs for default privs: