SQL – Check User Work Item Permissions

Sometimes in the Cireson Portal you may find an analyst complains that they are unable to access a certain work item.

The following SQL query allows you to check their permissions. It will output the WI details and also the user permissions.

Run this against the ServiceManagment db…

exec spCheck_UserWorkItemPermissions ‘username‘,’workitemID

1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s