Under SQL 6.5 a user of ISQL/W or other tools could only see the databases they had permission to in the drop down boxes, not under 7.0, why?

A. This is because under SQL 7.0 the code necessary to evaluate all the roles/NT groups etc. was deemed too expensive. However this is a legitimate security concern and Microsoft are thinking about changing the way this works back to the old behaviour.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish