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