How to access the Attributes set within the Role Authorizations

Topics: General Topic, NetSqlAzMan Core
Nov 13, 2012 at 8:44 PM

Management Console for .NET SQL Authorization Manager Ver.

SQL Server 2008 R2

Using simple web app to test in VS 2012


My question:

It seems that I can add Attributes within the Role Authorization subtree.  I am adding these attributes to the Active Directory User object in the 'Manage Authorizations' menu option within one of the role groups.


What I cannot figure out is how to access this Attribute Value, per Active Directory User.  I have tried all logical hierarchical paths, given the 12 tutorials.


Any advice would be appreciated.

Thank you,



Nov 13, 2012 at 8:57 PM
Edited Nov 13, 2012 at 8:58 PM

Using this method (SqlAzManStorage class):


public AuthorizationType CheckAccess(

 string StoreName,

 string ApplicationName,

 string ItemName,

WindowsIdentity windowsIdentity,

DateTime ValidFor,

bool OperationsOnly,

out List<KeyValuePair<string, string>> attributes,

params KeyValuePair<string, Object>[] contextParameters



Attributes are returned as an out parameter by the CheckAccess method … and result will be “all attributes of authorized items only”.


Andrea Ferendeles / NetSqlAzMan Project Coordinator
Web /

Nov 16, 2012 at 9:52 PM

Thank you for your quick reply.

Much appreciated.




May 7, 2013 at 11:52 PM
I have setup Attributes in the Role Definitions using the NetSqlAzMan console. My missing piece in your solution above is I don't know what the "Item" or "Role" is for the user?

Looking at the Items Table in the database I see that all roles are defines as ItemType 0. Do I use that to determine the Role/Item name?

I need to get the User's Role(s) first then I would guess I can use the above class to return the attribute in that Role.

So first, how do I get that Role.

I have to do a proof of concept by next week at the latest in order to use NetSqlAzMan on this application. Help?

using version

May 8, 2013 at 6:42 AM
Hi Eric,
but do you have read the NetSqlAzMan pdf guide ?
Excpecially the tutorial 1.
Please check also the Video Tutorial

I think you can find there all your answers.