-- PROCEDURE GRANTS PERMISSION TO A GIVEN SQL USER-- TO ALL OBJECTS WITHIN A GIVEN CATALOG CONTEXT-- STORED PROCEDURES, VIEWS, TABLES, SELECT FUNCTIONS, EXECUTE FUNCTIONS-- MODIFY AS REQUESTED-- SAMPLE EXECUTE -- EXECUTE sp_All_Object_Security_Grant 'WUA'
2006-04-20 (first published: 2006-03-14)
172 reads
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
This is something I touched on back in 2017 a little after the Live...
Comments posted to this topic are about the item Is Data the Future of...
Basically, I just want to write a cleaner query than what I have, which...
Hi All, Last week we got users complaining about specific database performance and they...
Ask SSC