Solved

How do I set this up in ASPX?

Posted on 2013-06-18
1
189 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 34

Accepted Solution

by:
Paul MacDonald earned 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

828 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