question

Waqar_lionheart avatar image
Waqar_lionheart 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
permissionsdatabase-objectsdomainsad groups
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Adedba avatar image
Adedba answered
When you check this user's profile in active directory is he perhaps part of another group aswell as the dev group?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Not a group that's mapped as a log in.
0 Likes 0 ·
Adedba avatar image
Adedba answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.