Is it possible to create a unique login (and hence a unique connection string) for every user of a private web application (less than 10,000)? This is of interest because it might provide a way to use commercial tools like SQL Audit to audit user actions. SQL Audit can distinguish between connection strings but of course not between users all coming in on the same connection.
As a second question, from a stored procedure, can I check to see if a server login exists, and if not, create it?
Thanks in advance for any suggestions.