Are there any concerns when using a local temp table (#sometable) and connection pooling? Is it possible for a user to hop on a previously used connection and session...

Does the user have permissions to execute the Stored Procedure?