I want to set up three different environments on Oracle: DEV, REC and PROD for Development, Recipe and Production. In each of these environments, EDE, PARAM, DTM users must be set up, which are also Oracle schemas.
Have you set up Oracle DBs before? How much do you know about setting up DBs? What have you tried and what went wrong? Have you read and followed the Oracle DB manuals for your version of DB?
All things are lawful, but not all things are profitable.
Do you mean different Users should have access to different schema? Or All users should access all Objects in a schema ? Environments are Connections Or multiple schema ? You can configure these details in Oracle Administrator Page. Please be specific.