All Questions
6 questions
0
votes
1
answer
125
views
Will an AD Account inherit all the User Mappings to databases that it's parent AD Group is mapped to?
If a Windows AD Group and an AD Account that belongs to that AD Group are both setup as Logins on a SQL server, will the AD Account Login inherit all the User Mappings that it's parent AD Group Login ...
- 39.5k
0
votes
1
answer
248
views
Unable to drop database user without login
One of our developers with blanket privilege on a database wanted to create a regular user mapped to a login when what he mistakenly created was a user without login and now I'm unable to remove the ...
- 1,550
5
votes
3
answers
4k
views
Who is the person using a SQL login?
Is it possible to find out who used a SQL-Server login?
Let's assume we suspect a person to abuse a SQL login that is supposed to be used by an application only to logon to SQL-Server. Is the domain ...
- 4,807
0
votes
1
answer
2k
views
Implication of owned schemas for a user having db_owner privilege
Importance of "Schema owned by the user"?
The user is db_owner for the db. Is it required to select owned schemas?, or else it will own all the schemas as it is a db_owner? Please provide me ...
- 31
2
votes
1
answer
2k
views
Best way to remap database login to new database user and keep previous database user
Here's what my environment looks like:
Active Directory (mydomain.local)
- Groups
- group01
- Members
- aduser01
SQL Instance
- Logins
- mydomain\group01
- ...
- 175
1
vote
1
answer
195
views
Preventing orphaned users in SQL Server 2008 R2
I've recently had a situation where a database was refreshed from production to staging, and the users on the database ended up orphaned.
These are sql server users, not mapped to windows credentials....
- 2,631