Skip to content

Instantly share code, notes, and snippets.

@mariuz
Last active August 29, 2015 13:56
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
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