Posts Tagged ‘Sessions’

New Command: SET_SESSION_PARAMETER

Monday, February 16th, 2009

SET_SESSION_PARAMETER OEM_TRANSLATION_STATE  allows users to programmatically enable or disable OEM to ANSI translation. Once enabled, this affects all data files used by the application. This is equivalent to adding “TRANSLATE_OEM_TO_ANSI 1″ in the INT file.  SET_SESSION_PARAMETER OEM_TRANSLATION_STATE can be called at any time.

(more…)

User Information from MySQL

Monday, February 25th, 2008

This example returns user information from MySQL:
(more…)

Client Authentication in PostgreSQL

Sunday, February 24th, 2008

If we choose the default installation for PostgreSQL, the client authentications are created as trust connection. So if we trying to connect to database by using a wrong password the connection will be established. To avoid this we can edit the pg_hba.conf and change the column METHOD from ‘trust’ to ‘password’. After changing we must restart Database Server.