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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jlrsov

    Bindview Patch Deployment and SP4a

    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
  2. jlrsov

    How to tell if BUILTYIN\Administrators login is needed

    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...
  3. jlrsov

    Using CDOSYS instead of SQLMAIL in a sp for failed logins

    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...
  4. jlrsov

    A SQL script to run through logins to list permissions and roles?

    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
  5. jlrsov

    A SQL script to run through logins to list permissions and roles?

    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
  6. jlrsov

    Does anyone have a script that lists database permissions

    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
  7. jlrsov

    A SQL script to run through logins to list permissions and roles?

    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...

Part and Inventory Search

Back
Top