We are going to use Bindview Patch Deployment utility to automatically install SPa across a wide range of SQL Server 2000 servers. Is anyone aware of possible issues arising from such a deployment?
Thanks,
Jim Ruddy
Here is a thorny problem for security:
Is there any way to tell WHO is logging in and using the BUILTIN login and WHO the real members of it are? I run the
exec sp_helplogins BUILTIN\Administrators
script, but it gives back no memebership info at all.How can one investigate beforehand...
SQL Server mag had a script from Canadian GIlles Despaties that audits failed logins intelligently and emails the results in SQLMAIL. My problem is that SQLMAIL is not used in our SQL Servers, and I was wondering how to insert CDOSYS instead in the following code so that the CDOSYS utility is...
dear mrkenny
I ran the above script for 2000 on one of the servers that had 10 logins created in the Security folder and all that came up was 648 rows of "dbo" and "INFORMATION_SCHEMA" as Grantor...
Am I missing something? Where are the ten logins with their database permissions listed?
Jim
I have about 1500 SQL Server 2000 servers to scan, and this script doesn't work with SQL Server 2000. Do you have an older version that would do the trick?
Thanks,
Jim
What I need is a script that will go through each login in the security section login list and tell, for each, not the server roles but the database permissions that each login has. sp_helprotect doesn't do this for each login.
Thanks in advance
Jim Ruddy
To all SQL Server gurus, please help!
Does anyone has a SQL script that can start at the beginning of the logins (in the Security section for that server) and list, for each login, their respective server roles and database permissions? What about checking or scanning through a whole group of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.