Menu ▾ ▴

#391 MSSQL list of users only retrieved from default db

Squirrel SQL
open
nobody
None
5
2015-01-08
2006-06-21
Anonymous
No

(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

Discussion


Log in to post a comment.