Multiple Schema in One DB

[itishree sukla <itishree.sukla@xxxxxxxxx>]

Hi all,

I am in a requirement to have multiple schema in one Database.

Schema structure will be same with respect to DB all db objetcs like tables, procedure.

However each schema will be accessed by one one application.

Problem is as all DB objects are same, when application is calling to a schema we have set search_path='schema name'  in our procedure level. Now we want to get rid of that.

I know we have do it based on ROLE Level, question is having more than one user defined schema is it achievable, i have done a small exercise, seems to be it is taking the first schema defined in the set search_path.

As i am in urgent need of it, please help me.

Regards,

Itishree