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: )

218 reads

Blogs

On Speaking Well

By

Professor Patrick Winston of MIT used to give a one-hour talk about how to...

Monday Monitor Tips: Oracle Custom Metrics

By

One of the popular features of Redgate Monitor has been the ability to add...

Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes

By

When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...

Read the latest Blogs

Forums

Troubleshooting WQL in custom PBM conditions?

By mastershake

Hi, I'm currently trying to implement policy based mgmt with a condition to query...

Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups

By abdalah.mehdoini

We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...

The Vector Data Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Vector Data Type

Visit the forum

Question of the Day

The Vector Data Type

What is the vector data type in SQL Server?

See possible answers