Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Public role
- Thread starter icemel
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
SQL 2000 or SQL 2005?
Didn't I give you my script that checks security like a week or so ago?
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Didn't I give you my script that checks security like a week or so ago?
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #3
I found what I was looking for. I don't think your script shows public? I thought it only returned info for database users, not roles.
It was hard to decipher the information returned from the script - it returned about 5000 rows! But it was very thorough. Thanks again, I will use it when I require that level of detail on a particular user.
It was hard to decipher the information returned from the script - it returned about 5000 rows! But it was very thorough. Thanks again, I will use it when I require that level of detail on a particular user.
mrdenny
Programmer
- May 27, 2002
- 11,595
no problem. It can probably be tweaked to show the info you are looking for.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question