Technical Article

List User 's Permissions in Database

Do you ever need to look for a given user's permissions for security reasons or move the permissions for that user from test environment to production? This is a script, which will generate print statements, which can be use to view/grant, the permissions of all dbo objects, which the given user has, which is not […]

2004-08-16 (first published: )

598 reads

Technical Article

List User Permissions

Do you ever need to look for a given user's permissions for security reasons or move the permissions for that user from test environment to production? This is a script, which will generate print statements, which can be use to view/grant, the permissions of all dbo objects, which the given user has, which is not […]

2 (1)

2004-07-08 (first published: )

855 reads

Blogs

Honored to be a Microsoft MVP Again

By

I was renewed this week as a Microsoft MVP. This is my 15th award...

Thank You Kevin!

By

I don’t think I’m going too far out on a limb to call Kevin...

Daily Coping 6 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Establishing a Connection to PostgreSQL with GoLang

By sabyda

Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...

SSMS + Azure Data Studio 18.11.1 takes forever to install

By pietlinden

I had a previous version of SSMS and ADS installed, and somehow my install...

SSIS - Name of Excel Sheet - How to Clear Dropdown List?

By AMCiti

I am trying to create an SSIS package inside Visual Studio 2019.  This package...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers