search

typischmann / retail-crm

2 stars 1 forks source link

Add Authentication Service such as Encrption #42

Closed typischmann closed 9 years ago

typischmann commented 9 years ago

The encryption could be implemented by triggers. The authentication is implemented as a function/stored procedure which can be called by JPA.

Postgres Encryption http://www.postgresql.org/docs/9.3/static/pgcrypto.html

Calling stored procedure(naitve sql) by JPA http://www.oracle.com/technetwork/articles/vasiliev-jpql-087123.html

typischmann commented 9 years ago

Add pgcrypto to database. Test the new sql script

typischmann commented 9 years ago

http://www.jonsamwell.com/url-route-authorization-and-security-in-angular/

tczhaodachuan commented 9 years ago

Where do we want to store the password and username? Do we want to store them into DB?

tczhaodachuan commented 9 years ago

All the angularjs routing authentications requires an authenticate from server side.

typischmann commented 9 years ago

we need to encrypt and store the password in DB, because we don't want to provide a extra public key infrastructure

tczhaodachuan commented 9 years ago

https://medium.com/opinionated-angularjs/techniques-for-authentication-in-angularjs-applications-7bbf0346acec http://demos.angularcode.com/angularcode-authentication-app/#/ Follow these tutorials