Hi,
I have an SC application for multiple users that has two connections. One with a database with the security tables which is the same for all users and a connection with the specific user data, When the user logs in I use the sc_connection_edit macro to connect the user to its own database.
Although this seems to work fine it seems to have issues when other users log in. Because they use the same connection (but not edited yet) they sometimes seem to have access to the database of the other user.
As alternative I can use the sc_connection_new to create a new connection, that only exists during the session and then change the second connection to this new connection.
Can anybody advise what to use and if there is a difference between the two working modes?