Tracking Permission Dependencies

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Tracking Permission Dependencies

Postby Barry H » Wed Aug 31, 2011 1:51 pm

Hi All,

Is it possible to track the dependent objects of a particular user or role? Also is it possible to show server login's in SQL Dependency Tracker?

Barry
Barry H
 
Posts: 6
Joined: Wed Aug 31, 2011 1:47 pm

Postby Chris Auckland » Thu Sep 01, 2011 4:10 pm

Thanks for your post.

Users and Roles are displayed as objects, so you will be able to see their dependencies in the diagram.

Server level logins are not included in the diagram as we only show objects at the object level within the database.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby Barry H » Thu Sep 01, 2011 4:35 pm

Hi,

Thanks for your response. I have had another look at this and it still doesn't appear to be doing what im after.

What I was looking for was to be able to add a user and all table, views, functions and SP and be able to see what objects that user has permissions to.

Barry
Barry H
 
Posts: 6
Joined: Wed Aug 31, 2011 1:47 pm

Postby Chris Auckland » Thu Sep 08, 2011 1:24 pm

Hi Barry,

Sorry for the delay. I've looked into this and you're right.

Personally, I would have assumed it would show you the relationships between the users and the objects but it doesn't. I suppose the permissions aren't really dependencies as both objects can function without the other one.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests