Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
How to allow users to log on only from my application not from pgadmin
- From: "Andrus" <kobruleht2(at)hot(dot)ee>
- To: pgsql-general(at)postgresql(dot)org
- Subject: How to allow users to log on only from my application not from pgadmin
- Date: Sun, 28 Jan 2007 23:46:27 +0200
My application implements field and row level security. I have custom table of users where user privileges are described. However user can login directly to database using pgAdmin. This bypasses the security. How to allow users to login only from my application ? I think I must create server-side pgsql procedure for login validation. How to implement custom authentication in server side ? How to force PostgreSQL to call stored procedure for user logon validation when user logins to PostgreSQL ? Andurs.
- Follow-Ups:
- Re: How to allow users to log on only from my application not from pgadmin
- From: Bruno Wolff III
- Re: How to allow users to log on only from my application
- From: Raymond O'Donnell
- Re: How to allow users to log on only from my application not from pgadmin
- Prev by Date: Re: counting query
- Next by Date: text storage and parsing errors
- Previous by thread: Firing triggers based on certain Insert conditions
- Next by thread: Re: How to allow users to log on only from my application
- Indexes: