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. 3.6.0.15.

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,

 

Jason

Coordinator
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 / http://netsqlazman.codeplex.com
email aferende@hotmail.com

Nov 16, 2012 at 9:52 PM

Thank you for your quick reply.

Much appreciated.

 

 

-Jason

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 3.6.0.15

Thanks,
Eric
Coordinator
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.
Regards,
Andrea.