title: MSSQL Server maximum users and privileges
body: <p>I have a design question.
  We have to troubleshoot a custom application due to timeouts in the database connection. The application is hosted within a Sharepoint plattform, which has a timeout of 30 seconds set. But the timeout is not the root cause.</p>
  
  <p>We suspect the root cause in how the application handles users and authorizations.</p>
  
  <p>The users are authenticated against an active directory and are kind of registered within the MSSQL Server, so each user will also have its own account in the database. For each user and stored procedure/view, the application grants privileges within the database.</p>
  
  <p>So in the end it uses the mechanisms of the database to enforce read and write access rights.</p>
  
  <p><em>Edit:</em>
  The application allows to define roles dynamically to separate privileges for different organizations. These organizations are known to the application only.
  But these roles are not reflected in the database. Instead they are converted into single privileges for each database object.</p>
  
  <p>Currently we have 1300 users and about 4000 privileges.
  And currently a query to show properties/privileges for one user takes about 1-1,5 minutes.</p>
  
  <p>Does the MSSQL Server have some limitations in terms of maximum suggested amount of user accounts and privileges since too many accounts and privileges may cause performance issues?</p>