Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). Provide login access to all databases in an instance   Article Abstract: Automating login creations and and assigning appropriate rights - a script.   Read this article...

Related Articles - For Members. All Articles By Author SQL Server 6.5 Security Modes Security Mandates: DBMS Row Level Security Security and the .NET Security Enhancements in Login object Using security procedures to troubleshoot SQL Server problems Enhance Your Transaction Flexibility With Embedded Stored Procedures Alter View, Create Function: Security for Assemblies Part I Regulatory Compliance 101 for the Overworked DBA Modeling Date Logic I: Date Arithmetic, Date and Time Datatypes, Date Formats, & Built-in Functions DB2 UDB security: Security plug-ins using the GSS-API security mechanisms (SPKM / LIPKEY)

RE: Provide login access to all databases in an instance
by Earl Gardner (posted: 7/21/2008 8:42:13 AM)
Great Idea! How about a script to remove the users once they no longer need or should have access to the Dbs? That would make this script full circle, valuable.

RE: Provide login access to all databases in an instance
by Thomas Pieries (posted: 7/24/2008 11:08:16 PM)
Thanks for the feedback Earl , let me do something about that