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

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

845 reads

Blogs

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

Read the latest Blogs

Forums

Software to send Report

By VastSQL

Hi Experts, Currently we are using SQL Server and Database Mail to send reports...

DBCC showcontig help

By vicky

Hello Team, I am using DMV dm_db_index_physical_status to replace the DBCC is sql server...

Difference between connection, session and instance

By michael.leach2015

I am having trouble finding some clear definitions of these things.  Are the following...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers