Security Best Practices: Is This Reasonable?
От | Tom Browder |
---|---|
Тема | Security Best Practices: Is This Reasonable? |
Дата | |
Msg-id | CAFMGiz_sCOfuixGZLGcfbGigK523ixmwaYL-2jM5Z6bH-y8Gkw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Security Best Practices: Is This Reasonable?
|
Список | pgsql-novice |
I would appreciate any critique of this security model I want to use for my planned web-accessible family database: I have a working PostgreSQL running on a remote Linux web server running Apache 2. I want to allow web access to a database but want to restrict row update to a row owner. All access to the site is by SSL/TLS, and I use Apache htdigest passwords to control access to the directory containing the database Perl cgi scripts. I plan to have every table have a field (called 'owner') which will be filled in by the accessing user's name when a new row is created (I will really use an integer key unique for each user). The site user names and passwords will be the same as the database user names and passwords. I plan to have user names identified through the CGI environment and then, for any attempted update of any row in any table, disallow it if the user and owner do not match. Thanks for any suggestions. Best regards, -Tom
В списке pgsql-novice по дате отправления: