Return User Roles
A stored procedure that will return the roles assigned to a user. Can be called from software to validate a user set up with Windows Authentication.
2009-03-25 (first published: 2009-02-19)
1,155 reads
Windows Authentication
Blogs
SQLSaturday Automatic Messages
By Andy Warren
For those who haven’t used the admin tools for SQLSaturday when an event is...
Using the Announcement/News Part of SQLSaturday
By Andy Warren
One of the interesting but not often used features of the SQLSaturday tools is...
SQLSaturday Orlando 2019 Begins
By Andy Warren
We’ll be event number 911, set for September 28th at our usual location at...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Transaction was deadlocked on lock | communication buffer resources with another
I have a table that contains case numbers. The following stored procedure assigns a...
Microsoft and Oracle Cloud Partnership
Comments posted to this topic are about the item Microsoft and Oracle Cloud Partnership
Ask SSC