Instantly share code, notes, and snippets.

Embed
What would you like to do?
firebird3 srp auth example
import firebirdsql
conn = firebirdsql.connect(
host='localhost',
database='/tmp/test.fdb',
auth_plugin_list=("Srp",),
user='SYSDBA',
password='masterkey',
wire_crypt=True)
cur = conn.cursor()
cur.execute("SELECT r.SEC$USER_NAME, r.SEC$FIRST_NAME, r.SEC$MIDDLE_NAME, r.SEC$LAST_NAME, r.SEC$ACTIVE, r.SEC$DESCRIPTION FROM SEC$USERS r ")
for c in cur.fetchall():
print(c)
conn.close()
@mariuz

This comment has been minimized.

Owner

mariuz commented Feb 24, 2014

output is

('SYSDBA', None, None, None, True, None)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment