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

596 reads

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

854 reads

Blogs

Daily Coping 24 Sept 2021

By

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

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Making Software Decisions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Making Software Decisions

Working with the Delete Activity in Azure Data Factory

By arindamxs

Comments posted to this topic are about the item Working with the Delete Activity...

Current Symmetric Key Algorithms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Current Symmetric Key Algorithms

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers