Toad World® Forums

RevEng SQL 2005 - not picking up SQL Logins for Global Groups TDM 3.6.6.7


#1

When I reverse engineer a SQL 2005 database, it is not picking up any of the SQL Logins that are MS Domain Global groups. I am a member of some of these groups and I can see the groups in SQL Server Management Studio.

SQL logins that are MS Domain user IDs are picked up just fine.

Any help is appreciated.

Thank you


#2

Hi,

TDM is able to load all principal types that can be loaded from database - accordingly to documentation. One exception exists, the “Application role”. We can load the following principal types:

SQL user
Windows user
Windows group
Database role
User mapped to a certificate
User mapped to an asymmetric key

I hope it helps,

Vaclav