(MSSQL) The list of users is only retrieved from
default db, not from the db selected (in the tree
view). For example if I have access to database A
(with users dbo, guest, mylogin, bizA) and database B
(with users dbo, guest, mylogin, bizB) [which is my
default], regardless of which database I expand in
the tree view (A or B), I will never see bizA objects
in database A. That is, unless I right click on
Database A and clck on 'Set Default Catalog', at
which point I lose the ability to see bizB objects
from database B.
mvogt99@gmail.com