x

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

more ▼

asked Jul 07 at 03:38 PM in Default

avatar image

Waqar_lionheart
101 4

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.

Jul 07 at 03:46 PM Waqar_lionheart
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x119
x12
x7
x2

asked: Jul 07 at 03:38 PM

Seen: 47 times

Last Updated: Jul 07 at 03:59 PM

Copyright 2017 Redgate Software. Privacy Policy