Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm using this configuration with SQL Server and MVC3.</p> <p>Web.config:</p> <pre><code>&lt;system.web&gt; &lt;roleManager enabled="true" defaultProvider="SqlRoleManager"&gt; &lt;providers&gt; &lt;clear /&gt; &lt;add name="SqlRoleManager" type="System.Web.Security.SqlRoleProvider" connectionStringName="SqlRoleManagerConnection" applicationName="YourAppName" /&gt; &lt;/providers&gt; &lt;/roleManager&gt; </code></pre> <p>....</p> <pre><code>&lt;authentication mode="Windows" /&gt; </code></pre> <p>....</p> <pre><code>&lt;connectionStrings&gt; &lt;add name="SqlRoleManagerConnection" connectionString="Data Source=YourDBServer;Initial Catalog=AppServices;Integrated Security=True;" providerName=".NET Framework Data Provider for OLE DB" /&gt; &lt;/connectionStrings&gt; </code></pre> <p>To inicialize roles:</p> <p>Global.asax.cs</p> <pre><code>using System.Web.Security; //// protected void Application_Start() { //You could run this code one time and then manage the rest in your application. // For example: // Roles.CreateRole("Administrator"); // Roles.AddUserToRole("YourDomain\\AdminUser", "Administrator"); Roles.CreateRole("CustomRole"); Roles.AddUserToRole("YourDomain\\DomainUser", "CustomRole"); } </code></pre> <p>In your Controller</p> <pre><code>[Authorize(Roles ="CustomRole")] public class HomeController : Controller { </code></pre> <p>To manage users</p> <pre><code> public class Usuario { public string UserName { get; set; } public string RoleName { get; set; } public string Name { get; set; } public const string Domain = "YourDomain\\"; public void Delete() { Roles.RemoveUserFromRole(this.UserName, this.RoleName); } public void Save() { if (Roles.IsUserInRole(Usuario.Domain + this.UserName, this.RoleName) == false) { Roles.AddUserToRole(Usuario.Domain + this.UserName, this.RoleName); } } } </code></pre> <p>Users Class</p> <pre><code>public class Usuarios : List&lt;Usuario&gt; { public void GetUsuarios() //Get application's users { if (Roles.RoleExists("CustomRole")) { foreach (string _usuario in Roles.GetUsersInRole("CustomRole")) { var usuario = new Usuario(); usuario.UserName = _usuario; usuario.RoleName = "CustomRole"; this.Add(usuario); } } // public void GetUsuariosRed() //Get Network Users (AD) { var domainContext = new PrincipalContext(ContextType.Domain); var groupPrincipal = GroupPrincipal.FindByIdentity(domainContext, IdentityType.SamAccountName, "Domain Users"); foreach (var item in groupPrincipal.Members) { var usuario = new Usuario(); usuario.UserName = item.SamAccountName; usuario.Name = item.Name; this.Add(usuario); } } </code></pre> <p>You can create an "Admin" controller like this, to manage the users:</p> <pre><code>[Authorize(Roles = "AdminCustomRole")] public class AdminController : Controller { // public ActionResult Index() { var Usuarios = new Usuarios(); Usuarios.GetUsuarios(); return View(Usuarios); } [HttpGet] public ActionResult CreateUser() { var Usuarios = new Usuarios(); Usuarios.GetUsuariosRed(); return View(Usuarios); } // </code></pre> <p>In my application, custom roles are fixed.</p>
    singulars
    1. This table or related slice is empty.
    1. POMVC 4 Intranet Authentication with Custom Roles
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPablo Claus
    1. USPablo Claus
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMVC 4 Intranet Authentication with Custom Roles
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIn this configuration you are seeding the roles and the role-to-user mapping in the application. How would you provide a solution where you want to provide an administrator the ability to manage this information and provide them with a list of the domain users already in the system? And keep it integrated as new users are added to the domain?
      singulars
      1. PO
      1. USKevin Junghans
    2. COGood point. I just extend my answer.
      singulars
      1. PO
      1. USPablo Claus
    3. CO@Pabloker Great! So far I have been able to add the elements above and get the page to use the authorization from the table using a defined role in the controller. Hooray! However, a couple things aren't working. 1) If the current user cannot be found in the users table the page crashes with System.InvalidOperationException: No user found was found that has the name (domainname). 2) if the current user does not map to the role defined in the controller the page crashes: The resource cannot be found. /login.aspx How do I trap and handle these situations?
      singulars
      1. PO
      1. USSQLGrinder
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload