Schema Creation [message #562777] |
Sun, 05 August 2012 00:50 |
|
kumar_hi21@yahoo.com
Messages: 6 Registered: August 2012 Location: chennai
|
Junior Member |
|
|
I Am not cleared in One scenario...
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
|
|
|
Re: Schema Creation [message #562778 is a reply to message #562777] |
Sun, 05 August 2012 01:07 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
This is an Oracle forum. I have no idea what is considered best practice with Postgres, you had better ask the question somewhere more appropriate.
Regards, JW.
|
|
|
|
|
Re: Schema Creation [message #562782 is a reply to message #562780] |
Sun, 05 August 2012 02:43 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
No, no, 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.
Regards
Michel
|
|
|