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.
asked Jul 07, 2017 at 03:38 PM in Default
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
answered Jul 29, 2017 at 08:52 PM