2022-05-25
443 reads
2022-05-25
443 reads
2017-05-01 (first published: 2017-04-19)
1,030 reads
In this article, Thomas Knight analyzes and critiques the design of, and experience with, the "dual-level" user security in SQL Server. He then demonstrates a better theoretical alternative.
2014-02-04
4,140 reads
This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.
2010-02-24 (first published: 2010-02-04)
2,212 reads
This script basically retreives all database users thier database roles for a database.
2010-02-10 (first published: 2010-01-20)
3,436 reads
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
By Steve Jones
It’s been a good week at SQL Bits. This is my favorite conference, and...
Hi all, I am running the following query in SQL, trying to export some...
Please suggest practice on SQL Server RLS On the database level, defined users with...
Hello, I have 3 SSIS packages having connection manager defined with a userA. These...