Quick Start

  • 1) Create the NetSqlAzMan Storage DB on SQL Server
In order to use .NET Sql Authorization Manager, a NetSqlAzMan Storage DB must be created !
a) Open SQL Server Management Studio.
b) Create a Database with a name like 'NetSqlAzManStorage'.
c) Right click on Database created above and choose 'New Query'.
d) Load and execute script named 'NetSqlAzMan_SqlServer.sql' from the installation folder.
  • 2) Define the Structure
  • 3) Authorize Users
  • 4) Invoke the CheckAccess method from your application (add reference to NetSqlAzMan.dll)
using NetSqlAzMan;
using NetSqlAzMan.Interfaces;
string cs = "Data Source=(local);Initial Catalog = NetSqlAzManStorage;Integrated Secuirty = SSPI;";
IAzManStorage storage = new SqlAzManStorage(cs);
AuthorizationType authorization = storage.CheckAccess("My Store", "My Application", 
                      "My Operation 1", WindowsIdentity.GetCurrent(), DateTime.Now, true);

Last edited Oct 26, 2012 at 8:22 PM by aferende, version 3


zteven Feb 4, 2013 at 1:22 PM 
Typo in connectionstring, it should be:
string cs = "Data Source=(local);Initial Catalog = NetSqlAzManStorage;Integrated Security = SSPI;";