Skip to content

Instantly share code, notes, and snippets.

@mariuz
Last active August 29, 2015 13:56
Show Gist options
  • Save mariuz/9187640 to your computer and use it in GitHub Desktop.
Save mariuz/9187640 to your computer and use it in GitHub Desktop.
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
Copy link
Author

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