SQL Server User exists without Login
Posted on 2009-05-19
I'm working with a SQL Server database with the following security structure:
domain users --> domain groups --> SQL logins --> database users --> database roles --> permissions.
The database is associated with a municpal utility called CarteGraph. CarteGraph occasionally creates "on-the-fly" views to support GIS functionality. Here's the security construct associated with the views.
domain users --> MISSING LOGINS --> database users --> database schema --> view ownership.
CarteGraph generates the views using scripts and it may have generated the associated database users and database schema using scripts as well. The missing logins, however, make no sense. I looked at the properties for one of the database logins named COBNTOMAIN\bakes1. The properties dialog shows it to be associated with a SQL Server login named COBNTOMAIN\bakes1. Yet, if I look at the list of SQL logins, COBNTOMAIN\bakes1 is simply not there.