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? Any tips welcome, Lukas
