Add, delete, edit user
Moderators: gto, cipto_kh, EgonHugeist
Add, delete, edit user
someone have some idea how I can add, delete, edit users in firebird using zeos?
Codebue Fabio
P-Soft - http://www.p-soft.biz
Firebird La Comunità Italiana - http://www.firebirdsql.it
GestionaleOpen - http://www.gestionaleopen.org
P-Soft - http://www.p-soft.biz
Firebird La Comunità Italiana - http://www.firebirdsql.it
GestionaleOpen - http://www.gestionaleopen.org
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)