Unanswered: Application Access Authencity (Security) in Postgres ?
Do we have Application level Security Access (Authorization) in Postgres?
I mean to say as in case of Sybase Database, We have something like
SET TEMPORARY OPTION "CONNECTION_AUTHENTICATION='Company=ABC; Application=XXX; Signature=1234567890'";
Java Application accessing the Sybase Database sets the above CONNECTION_AUTHENTICATION variable with the Signature provided by the Sybase. Above Statement is executed by Sybase Server and it validates the authenticity of the Application thereby ensuring that Application that provides the correct CONNECTION_AUTHENTICATION value only has access to the Sybase Database.
Do we have similar kind of functionality provided in Postgres?