On 11-04-2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote: > Hi @all! > > I'm trying to implement some sort of user manager into an app and want > to use the firebird-users and roles as user and authentification > source (using FB 3). > > Most of it works perfectly. There's just one little problem: > If I create or drop a user via CREATE USER or DROP USER and do a > "SELECT * FROM SEC$USERS" afterwards the change is not visible - the > new user is missing, the dropped user is still in the list. > > I'm using the same transaction for all the commands but still I have > to issue a COMMIT for seeing the changes in the user list. > > Now I'd love to use the transaction-mechanism for giving the user of > my app a possibility to revoke the changes made. > > Can this be achived somehow?
No, it cannot. Creation of the user happens in a different database, and changes in that database aren't visible until the commit happens (at which time the commit in the security database happens as well). Mark -- Mark Rotteveel