ALTER SESSION modifications are specific to that particular session and are gone when the user disconnects. I don't see any implications, if at all there are some implicataions, those are specific to session not database.