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.
Toad for SQL Server can provide user connect same server in two different connection with diffrent login at the same time. It also provide user multi Editor opened under different connections.
For example, we can create a connection named "ConnectionA" use AdminUser as login. Then we open an editor window . This editor window will use ConnecitonA. We create a connection named "ConnectionB" use NonAdminUser as login. Then we open an editor window. This editor window will use ConnectionB. We also can find which connection the editor is using at status bar. it's at lower right corner in toad window. Like the picture below.