Schema Creationhttp://www.orafaq.com/forum/./mv/msg/183223/562777/#msg_562777
I am newly developed one DB design ...

Actually My ERP have a four module (FINANCE,HR,INVETORY,PRODUCTION)

mY dOUPT IS ?

Each Module developed a seperate Schema,OR Single schema ...

Which one is better?How to build a strong Security Level ?
The data is very very Important One ?
I need a advantege and disadvantage of Both ?
How to develop a ER diagram in this module Any Ref...

I am eagerly waiting for your Reply...

Thanks
Kumar
]]>kumar_hi21@yahoo.com2012-08-05T05:50:24-00:00Re: Schema Creationhttp://www.orafaq.com/forum/./mv/msg/183223/562778/#msg_562778
Regards, JW.
]]>John Watson2012-08-05T06:07:02-00:00Re: Schema Creationhttp://www.orafaq.com/forum/./mv/msg/183223/562779/#msg_562779
2/ AS your main concern is security, I think it is better to separate them into different schemas. Then create roles (does this exist in Postgres?) for each functional needs and assign one or several roles to each user account.

The prime directive for security is: "give each account the least privileges it needs to achieve his tasks".
This can lead to activate/deactivate some privileges/roles depending on the current task.

Regards
Michel
]]>Michel Cadot2012-08-05T06:10:22-00:00Re: Schema Creationhttp://www.orafaq.com/forum/./mv/msg/183223/562780/#msg_562780
kumar_hi21@yahoo.com2012-08-05T06:38:35-00:00Re: Schema Creationhttp://www.orafaq.com/forum/./mv/msg/183223/562782/#msg_562782
Postgres is not the same as Oracle, no relation at all, it is the object-relational version of Ingres (it is Post-Ingres). Even the roles I mentioned in my previous post are not the same notion than Oracle one.
I gave you the basic principles, only YOU know what are the actual security requirements.
I think you should post this in a Postgres forum.