Add, delete, edit user

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
fcodebue
Junior Boarder
Junior Boarder
Posts: 32
Joined: 05.04.2008, 16:02
Contact:

Add, delete, edit user

Post by fcodebue »

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
mrLion
Senior Boarder
Senior Boarder
Posts: 71
Joined: 20.03.2010, 10:17

Post by mrLion »

And what, SQL "CREATE / alter / drop USER" is not suitable? :roll:
seawolf
Zeos Dev Team *
Zeos Dev Team *
Posts: 385
Joined: 04.06.2008, 19:50
Contact:

Post by seawolf »

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)
Post Reply