Re: [firebird-support] List Users after CREATE/DROP USER without commit
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
Re: [firebird-support] List Users after CREATE/DROP USER without commit
11.04.2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote: > 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? User management is outside of database and performed in an autonomous transaction. To see results of the query you, probably, have to use read-committed isolation level. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] List Users after CREATE/DROP USER without commit
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
