How to secure PostgreSQL Data for distribute?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How to secure PostgreSQL Data for distribute?

Premsun Choltanwanich
Dear All,
 
     I need to distribute my application that use PostgreSQL as database to my customer. But I still have some questions in my mind on database security. I understand that everybody  who get my application database will be have a full control permission on my database in case that PostgreSQL already installed on their computer and they are an administrator on PostgreSQL. So that mean data, structure and any ideas contain in database will does not secure on this point. Is my understanding correct?
 
     What is the good way to make it all secure? Please advise.
Reply | Threaded
Open this post in threaded view
|

Re: How to secure PostgreSQL Data for distribute?

Nikola Milutinovic-3
Premsun Choltanwanich wrote:

> Dear All,
>  
>      I need to distribute my application that use PostgreSQL as
> database to my customer. But I still have some questions in my mind on
> database security. I understand that everybody  who get my application
> database will be have a full control permission on my database in case
> that PostgreSQL already installed on their computer and they are an
> administrator on PostgreSQL. So that mean data, structure and any
> ideas contain in database will does not secure on this point. Is my
> understanding correct?
>  
>      What is the good way to make it all secure? Please advise.


If you want to keep your data/schema "secure", you have to keep it at
your own place and that is just the first step in making it "secure".
Espionage, and that is what basically bothers you, is a complex field of
enterprize and there is no "one size fits them all".

Your first step is keeping the DB at your site and letting your
customers connect to it. This may present a huge problem, but there is
no other way. No encryption would work, trust me.

Nix.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster