Improve company productivity with a Business Account.Sign Up

x
?
Solved

How do I set this up in ASPX?

Posted on 2013-06-18
1
Medium Priority
?
198 Views
Last Modified: 2013-07-24
Hello Experts!

I am working with a developer and I think we are stumped, so here I am asking for help.  I have a website that requires that you log into it using your email address.  The website should be designed so that multiple orgs can use it.  The users are stratified into 3 categories per org.  (there is a super user who can see all, but thats a consideration for later)


Org 1
Read user  (read only)
Admin User (upload files for basic users)
Basic user

Org 2
Read user  (read only)
Admin User (upload files for basic users)
Basic user

The websites purpose is to store documents for the basic users.  I want a user for org 2 to be able to contact the admin user of to request access to org 1's documents, and for the admin user to be able to provide read only access for either the user specifically or the org.

So far we are stuck because some of the documents are generated via generic pages.  Is there a way so that the admin user can upload documents to a webpage that I can reference as a specific dynamic webpage for later?

ASPx is not my forte.  I need help with how to setup the rights and the webpages.  If this is better split as questions, let me know.  DB backend is SQL 2008

Fox
0
Comment
Question by:the_b1ackfox
1 Comment
 
LVL 35

Accepted Solution

by:
Paul MacDonald earned 2000 total points
ID: 39259332
As I understand your question, it sounds as if you need at least three things:
A table of users (which includes their user status, and what organization they belong to)
A table of documents (which includes the document or a link to the document, and which organization owns it, maybe a description, maybe some keywords to search on)
A joining table that lists which users have access to which documents

When a user tries to open a document, the system would determine the level of the user, which organization the user belonged to, and which organization the document belonged to. If the user were an admin user, and the document belonged to the admin's organization, the user would be granted access.  If the user were a basic user, the joining table would be consulted to determine if the user were allowed access to the document.  It's not clear from your description how read-only users work, so I'll leave that open.

How the users access documents would have to be an exercise for you.  Whether they pass in a document ID, or there's a table of contents, or some sort of keyword search would depend on how you see users interacting with your web site.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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 …
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
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
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

606 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