OraFAQ Forum: Security » Schema Creation

Home » RDBMS Server » Security » Schema Creation (Postgres Sql)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Schema Creation [message #562778 is a reply to message #562777]

Sun, 05 August 2012 01:07

John Watson
Messages: 8964
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.

Report message to a moderator

Re: Schema Creation [message #562779 is a reply to message #562777]

Sun, 05 August 2012 01:10

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Note this is an Oracle forum
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

Report message to a moderator

Re: Schema Creation [message #562780 is a reply to message #562778]

Sun, 05 August 2012 01:38

kumar_hi21@yahoo.com
Messages: 6
Registered: August 2012
Location: chennai

Junior Member

Thanks For your reply ....Postgres is the oracle open source ..same as Oracle ...U assum with oracle ...Tell me your advice ...How to design DB And ER Diagram

Report message to a moderator

Re: Schema Creation [message #562782 is a reply to message #562780]

Sun, 05 August 2012 02:43

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	DBMS_SCHEDULER
Next Topic:	Ensuring read only access to any table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 19:13:17 CST 2025