Solved

How do I set this up in ASPX?

Posted on 2013-06-18
1
187 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 33

Accepted Solution

by:
paulmacd earned 500 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

771 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now