Postgresql – postgres authentication external

authenticationpostgresql

I have to implement some safety authentication rules on postgresql DB with a windows server. For example, rules may be "users not used for a period longer than three months will be locked" or "postgres enforces account lockout after a set number of failed login attempts."

Using authentication "standard" ( md5 on pg_hba.conf) I think is not possible. I think that with PAM it would work. However, PAM does not exist on windows server. Any ideas?

Best Answer

Postgres has an option "valid until" that specifies user's password expiry Date&time. but, I believe, what you are asking can be done as an application feature not the Database feature.

Related Solutions

Sql-server – Integrated Security Success on Master, Fails on Other Database

In SQL Server, as long as a LOGIN is valid, it will have access to the master database in a public role. This is both for historical and practical reasons. For example, stored procedures beginning with "sp_" are searched first in the master database and will execute from there. The implication is that users need to first have access to the master database to begin with. tempdb is another database that allows user access via the public role.

User databases do not have this as a default setup, so unless the Login is specifically given permission, or has server-wide roles such as "sysadmin", it will not be able to switch to the database context, hence your error.

The fact that you manage to log in at all using the machine account means that it is either explicitly a created LOGIN, or is a member of a group that appears under "Logins" when you browse the Object Explorer in SQL Server Management Studio.

[SERVER\Instance]
    Security
        Logins
             .... here ....

You can specifically assign roles or grant execute permissions to the machine account:

use other;
exec sp_addrolemember db_datareader, [DOMAIN\IIS_SERVERNAME$]
GRANT EXECUTE ON sp_myproc TO [DOMAIN\IIS_SERVERNAME$]

Sql-server – SQL server windows authentication through network

Do the username and password match between the network pc and the sql machine? I also found this link regarding, xp home. I am not sure what version of XP you are using.

https://serverfault.com/questions/54761/pass-through-authentication-does-not-work-with-a-specific-account-in-windows-xp

Best Answer

Related Solutions

Sql-server – Integrated Security Success on Master, Fails on Other Database

Sql-server – SQL server windows authentication through network

Related Question