asked
user in group adds himself as a user to database
Hi All, Sorry to bother but I have quite a strange situation. I have a member of our dev group (domain\devgroup) who is not mapped as a login on server level nor as a user in any database but everytime this guy logs in and creates an object on a database (i have this situation on a single database at the moment), he gets added as a user to the database domain\abc. He is still not showing as a user on server level. After creating the object, his object is automatically prefixed as domain\abc.objectname (I can understand why that is). However, my real concern is this is not happening with any other member of this dev group. Any help is really appreciated. Regards, Waqar
One thing i forgot to add is that this user appears in GUI as disabled (it has a little red downwards arrow) But the schema is continued to be prefixed with this user domain\abc... Super strange even though the user is showing as disabled.
When you check this user's profile in active directory is he perhaps part of another group aswell as the dev group?
I am assuming this is a non production database? Is it possible that the database is being restored from a backup on a regular basis and you are seeing the objects post restore? This would explain the orphaned user situation
18 People are following this question.
