January 27, 2012 at 1:24 pm
In the list of users in the security tab for a database there is a down arrow next to the user (incredibly small). Can someone tell me what this means?
January 27, 2012 at 1:31 pm
No associated Login at the server level, if I'm not mistaken.
Query "select * from sys.database_principles" and see what the "sid" column has. If NULL, there's no login associated with the user.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 27, 2012 at 1:32 pm
The user is disabled
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 27, 2012 at 1:33 pm
problem is this is a windows account
January 27, 2012 at 1:38 pm
It will only be disabled within SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 29, 2012 at 12:18 pm
User is disabled (in the database level) by revoking CONNECT permission.
USE <database>
GO
REVOKE CONNECT FROM <user>
GO
January 30, 2012 at 6:39 am
SQLRNNR (1/27/2012)
The user is disabled
Arrow next to a login at the server level means that. At the user level, it doesn't necessarily. I've got 2 user accounts in my ProofOfConcept database that have the arrow on them because there's no login.
Original question was about a user in the database, not about a login on the server. Can be user connection revoked, can be other things too.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 30, 2012 at 7:18 am
Use became orphaned, first time I have seen a Windows login do this. They had a few sp's that had an execute as statement that the developer's brought in, we removed them remapped the user and then re-ran the sp's and things are fine
January 30, 2012 at 7:24 am
I've seen it plenty of times. That's why it was my first thought on the subject.
Have to admit, I've never tried to deny connection on a user before. On a login, yes. Deny access to a certain database for a login, sure. But have a user in the database and deny connection? Nope. Never occurred to me.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply