Background: I'm trying to use ScriptCase to build a PHP front end for an existing Firebird 2.5 DB project. Mission critical change tracking in this project is years old, is self contained, and relies on CURRENT_USER.
Precursor to Problem: In ScriptCase, the entire project logs in as SYSDBA (or any "high level" user I choose). (ScriptCase has it's own user control system and change logging which I don't need and don't want) Problem: Because ScriptCase logs in as a high level user, all existing change tracking built into the Firebird DB will log all changes by all ScriptCase users as SYSDBA (or what ever high level user was used to log in) Possible Solution: If Firebird 3x has an SQL command that would allow a currently connected user to switch their login to a different user, then there is a spot in the ScriptCase login process that I could issue that SQL. Of course, I would supply the correct Login ID and password, and I would expect all security restrictions on the session to be adjusted to the new login ID. Question: Does FB3x have such an SQL command that allows a currently logged in user to log in as a different user? Many months ago I read somewhere that this is possible, but now I can't find any documentation on how to do it. Thanks in advance for any help you can provide.
