Premsun, > 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.
I think you have a different definition of "security" from most of us. There are techniques you could use that would prevent your customer from having easy direct access to the database on his machine -- but they would also prevent him from making backups or recovering from a computer problem. They'd also require a lot of work on your part. Overall, if your goal is to prevent your customer from having control of their own data, I don't think an open-source database is the best choice for you. ;-b -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings