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

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

872 reads

Blogs

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

SQL Saturday Oregon & SW Washington 2024

By

Wow I am so late in posting these notes! But this conference was amazing,...

Challenges Enterprises Face When Adopting AI

By

The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Sparse Column Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sparse Column Storage

The Managed Cloud Database Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Managed Cloud Database Options

Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 6...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers