Red Gate forums :: View topic - Tracking Permission Dependencies
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Tracking Permission Dependencies

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Barry H



Joined: 31 Aug 2011
Posts: 6

PostPosted: Wed Aug 31, 2011 1:51 pm    Post subject: Tracking Permission Dependencies Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Sep 01, 2011 4:10 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Barry H



Joined: 31 Aug 2011
Posts: 6

PostPosted: Thu Sep 01, 2011 4:35 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Sep 08, 2011 1:24 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group