Technical Article

Add all users to user databaes as readonly

I am new to writing scripts so dont blast be to bad.  This is a script to make all logins of a sql server readonly users to all user databases.  Mainly after a restore from a different server. (for reporting maybe) Any methods to optimize this script are fine.

You rated this post out of 5. Change rating

2014-10-27 (first published: )

213 reads

Blogs

Advice I Like: Take Two Trips

By

If you have any doubt about being able to carry a load in one...

Do Yourself a Favor, Check Out Woodler

By

I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love...

Vertically scaling SQL Server online in Kubernetes

By

One of the new features in Kubernetes v1.33 is the ability to resize CPU...

Read the latest Blogs

Forums

Analyzing Tempdb Spills and Usage Across Recursive Queries

By shukla.chandan12

Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...

Creating a new API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a new API in...

Deadlocks and Backups - Need help

By Mike-342950

Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...

Visit the forum

Question of the Day

Creating a new API in Data API Builder

If I run "dab init" to create a new API over a database, what parameters are required?

See possible answers