For instance, I want to have 2 tabs (Editor) open. One as an admin so i can create a stored procedure and grant execute permissions (say NonAdminUser). I also would like a tab open and logged on as NonAdminUser to try and execute the procedure. In essence test some security settings for a specific user.
The only way i see to do this is to change the connection properties for the server and then it changes all tabs open to that user. I would hope there is a way to change the user that is connected (via Editor) to a particular server without having to change the server connection properties to that server.
Is there a way to accomplish this?