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 […]

You rated this post out of 5. Change rating

2004-08-16 (first published: )

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

You rated this post out of 5. Change rating

2004-07-08 (first published: )

869 reads

Blogs

Redgate Clone Graduating Images

By

I wanted my own custom image in our internal Redgate Clone cluster, so I...

SQL Saturday Syracuse 2024 Recap

By

First Things First Thanks to every who came to my session, Asnwering the Auditor’s...

A New Word: Incidental Contact High

By

incidental contact high – n. an innocuous touch by someone just doing their job...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

How to load AML files SSIS or any other option

By JSB_89

Team, Please suggest or if you have an example please share the link for...

Visit the forum

Question of the Day

Adding Features During a SQL Server 2022 Upgrade

I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade?

See possible answers