Add, delete, edit user
Posted: 30.03.2010, 12:51
someone have some idea how I can add, delete, edit users in firebird using zeos?
Zeoslib Portal
This is the official forum of ZeosLib providing support to all ZeosLib users.
https://zeoslib.sourceforge.io/
Add, delete, edit user
Page 1 of 1
Posted: 30.03.2010, 13:28
And what, SQL "CREATE / alter / drop USER" is not suitable?
Posted: 30.03.2010, 17:40
I suppose you are using at least FB 2.0 ... there are 2 ways:
1. all information regarding users are stored in a file called security2.fdb so find this file, open it and do the changes (remember password are encrypted with SHA1)
2. you have to call isc_spb_sql_user,isc_spb_sql_pass,isc_spb_sql_role function and manage services (isc_spb_sql_* needed gsec command tool)
1. all information regarding users are stored in a file called security2.fdb so find this file, open it and do the changes (remember password are encrypted with SHA1)
2. you have to call isc_spb_sql_user,isc_spb_sql_pass,isc_spb_sql_role function and manage services (isc_spb_sql_* needed gsec command tool)