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

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

849 reads

Blogs

ASF 030: Benni De Jagere interview

By

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...

Going Dark in SSMS

By

I haven’t been a big fan of dark mode in many tools, but I’ve...

Figuring Out How To Hide Production Data

By

There’s a really simple conundrum that we go through all the time. The best...

Read the latest Blogs

Forums

Query Optimization Level

By Grant Fritchey

Comments posted to this topic are about the item Query Optimization Level

Now Is a Good Time for Choices

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Now Is a Good Time...

Design ideas for hostoric data & trending

By kazim.raza

Hi everyone, I have a use case (below) for which I am considering multiple...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

SQLCMD Output

See possible answers