[Webinar] Streamline your web hosting managementRegister Today


working with roles where there is multiple applications in the same datasource

Posted on 2008-02-08
Medium Priority
Last Modified: 2013-11-30
We have several applications that uses has the same users and for authentication they are stored in the same database with different application names.   Is there a way to get add a user but be able to add that user to any role in any of the roles for each application.   I have never used .net authentication before and this is all new for me.   THese applications were existing previous and I was asked to make find a way to manage user from one location.
Question by:krbnldy
  • 2
LVL 43

Expert Comment

by:Eugene Z
ID: 20858090
can you clarify what you are looking for?

<manage user from one location
Create admin application that will point to table where user vs permissions setup
and make validation of the user permissions based on info in the table that you may adjust:

user           application     role            permissions
krbnldy,        IE                admin             0                                  
EZ                 IE                user               1  

Author Comment

ID: 20868123
this is what I am trying to achieve
applicationName      userroles                            Users
\ABC                          admin,  Edit, ViewOnly      Can be just a few or many users
\DEC                          admin  (here the admin is seperate from the application above and may or may not be the same users

There are several applications and each application has can have the same users with different permission levels.

I want to manage all this fom one database as the users are all stored there.

Accepted Solution

krbnldy earned 0 total points
ID: 21298114
Since I have had no response on this question, i'd like to close it

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question