Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4.5 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4.5: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-31180-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4.5 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 25th, 2013, 02:00 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default Adding and deleting users and user groups

So you build a nice e-Commerce Application for the company you are working for and you want to create an Administrators group using the WSAT tool that comes with Visual Studio and so you add Karen, Lisa, Lori, Greg, Joe, Frank, Bill, and Ned to the administrators group. Then Karen gets transferred to a different department and Greg leaves the company. Then Clyde is transferred to your department and you need to add Clyde to the administrators group. So that now means you have to first go to the WSAT tool to add and remove those users from the administrators group on the application that is running on your local box to first test things out to see if they are working properly? Is that not correct? Now if you need to make those changes on the e-Commerce application database that is running on your remote production server, (which typically you as a developer don't have access to for obvious reasons) does that mean that you have to make changes to the SQL server database that holds the user information and their level of privileges on the application? What is the best approach? Have you or the DBA Upload the SQL Server Database using the SQL Server Enterprise tool using SSIS or is there some other way to do this that is more efficient and doesn't require any kind of advanced knowledge of using SQL Server's SSIS tool? Or can you or your DBA use SQL delete queries to delete them and if you or your DBA do that, will you need to cascade delete those users and references to those user off of more than one table? Isn't having to do this on a fairly regular basis kind of a hassle and time consuming? People come and go from companies and departments on a very regular basis as I am sure you are aware.
I remember in my Novelle networking class that I took in college while getting my degree in Robotics Engineering that you had to constantly to go in an add and remove users from user groups all the time, but under Novelle the utility to do so was pretty straight forward and not that difficult to use. Here in Visual Studio using Forms Authentication it is a different matter because there is a database involved. No quite so easy a thing to do.

Thank you and have a Happy Thanksgiving too :-)

Last edited by vbboyd; November 26th, 2013 at 02:42 AM..


Similar Threads
Thread Thread Starter Forum Replies Last Post
get user groups from Active Directory PorcupineRabbit Classic ASP Professional 1 February 6th, 2007 08:09 PM
Users, Groups and Permissions owain SQL Language 17 November 3rd, 2006 07:44 PM
User Groups survey Snib Forum and Wrox.com Feedback 1 January 21st, 2005 09:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.