kvarnerexpress
Dec 25 2005, 01:38 AM
I'm working on a piece of user/group authentication and I've run into a question that has to do with ASP coding, I think. I have very little experience with ASP, though. In essence, I have a couple of tables: users, groups, articles, Permissions for articles, and Groupmemberships... So, on a page, it opens up the article and looks for what groups have been given access to the article... It then looks at the userID (session variable) and determines what groups the user belongs to.... you I'll have 2 lists, the groups the user is in and the the groups that have access to the article... If there is any common between the two, then the user has access... otherwise they don't. So... User Group IDs^^^^^^^^^^^Article Group IDs 1^^^^^^^^^^^^^^^^^^^3 3^^^^^^^^^^^^^^^^^^^4 7^^^^^^^^^^^^^^^^^^^2 This person would have permission because the user belongs to one or more groups that have permission... or... User Group IDs^^^^^^^^^^^Article Group IDs 1^^^^^^^^^^^^^^^^^^^8 3^^^^^^^^^^^^^^^^^^^4 7^^^^^^^^^^^^^^^^^^^2 This person would get an access denied error.... So, my question is, how would I compare the two to see if there are any common elements in ASP or SQL? The data is in a MS SQL database... Thanks,
Reply
kvkv
Jan 30 2006, 05:51 PM
You have provided both the tables the same. I am assuming this is your table structure ----------------------------- User-group ----------------------------- user-id, group-id ----------------------------- group-articles ----------------------------- group-id, article-id You can use sql to check the permissions CODE select * from user-group, group-articles where user-group.group-id=group-articles.group-id and user-id=<user id> and article-id=<article id> replace <> with actual values. If this query returns results, then the user has permission. Otherwise, he doesn't. Note that it requires only one query.
Reply
Similar Topics
Keywords : difference, 2, queries
- What's The Difference Between 64 And 32 Bit?
Buying a new computer. (9)
Advertised Isp Speed Versus Actual Speed
Why is the difference? (4) You may want to visit this topic. That topic gave me the this question.
http://www.trap17.com/forums/page-3-t58513-s20.html My ISP advertise 1024/256 Kbit speed and
network details do say 1024. But my actual download speed is 100 kb per second and my upload limit
is 25 kps. So what's a Kbit? QUOTE(ivantoar @ Jun 11 2008, 08:49 AM) 394433 I
run at 768 kbps and I can download at 90kbps (stable). ....
Social Vibe, Join & Make A Difference!
(0) CLICK HERE TO JOIN SOCIAL VIBE So i was just browsing through my friend's music
profile.. and i found she supported this service called social vibe. What social vibe is, is kinda
like google ads, but the money goes to the charity of your choice of course you earn stuff too..
you get to feel great inside, and also earn entries for giveaways.. theres ipods, redbulls, xboxs..
everything, they have some amazing perks /tongue.gif" style="vertical-align:middle" emoid=":P"
border="0" alt="tongue.gif" /> well! so join through my link.. TO WRITE LOVER O....
What Is The Difference Between Addon Domain & Parked Domain?
Addon Domain & Parked Domain? (1) Hi, My question is what is the difference between an Addon Domain, Sub Domain & a Parked Domain? I
would also like to know what is an Addon Domain? Also what happens in trap17 when I add an addon
domain to my site? What does it actually do? Like does it create any folder for itself like on
addition of a sub domain. i would love to know about Addon Domains. **I'm a newbie in this
field (i.e domain, mx, A and all these networking stuff) so a detailed answer would be highly
appreciated.** Thanks in advance.....
Php Time Difference
how to handle different time zones (5) I'm trying to figure out how to deal with time entries in my mysql so it can be displayed
correctly on my end. On my local server its not a problem as the time created is in line with my
current time zone. The problem is when I use my scripts on trap17 server the time that gets created
is the time on that server so its off. I haven't really experiment on ways to handle this but
I've seen some articles related to his in the past but didn't bother to read them up. I want
to know if theres anyone who's dealt this with problem before and what solution d....
Molecule Vs Lattice
What's the difference? (2) I am doing chemistry right now. Our teacher, for homework, asked us to find the difference between a
molecule and a lattice. But a Google search reveals nothing, so I came here instead. Can someone
explain the difference between a molecule and a lattice, preferably not with too much jargon, as we
are barely beginning the course right now? Thanks.....
School And Knowledge: Whats Da Difference
(0) There are interesting observations upon this subject. QUOTE Tom Lehrer had an interesting view
of Mathematics, as is seen in his alliteration of the Periodic Table “There's antimony,
arsenic, aluminum, selenium, And hydrogen and oxygen and nitrogen and rhenium, .... And
chlorine, carbon, cobalt, copper, tungsten, tin, and sodium. These are the only ones of which the
news has come to Ha'vard, And there may be many others but they haven't been
discarvard.” Equally interesting is his "The Derivative Song" where everyone will learn ea....
Save The World... One Click At A Time!
20 seconds of clicking will help make a world of difference! (6) I encourage everyone to spread the word on this site... do your clicks and post this on your
bulletin spaces on your social networks. It's an easy way to help make a difference... and it
literally takes less than 20 seconds. /biggrin.gif" style="vertical-align:middle" emoid=":D"
border="0" alt="biggrin.gif" /> QUOTE Save The World - One Click At A Time!
On each of these websites, you can click a button to support the cause -- each click creates
funding, and costs you nothing! Bookmark these sites, and click once a day! ....
What Is The Difference Between Jdk 6 And J2sdk ?
(1) People please let me know what is the exact difference between JDK 6 and J2SDK. Guess both of these
installations belong to Java 2.....
Tos Queries
Some questions about the Trap17 Terms of Service. (2) Hey! I was just wondering if these were against the TOS: -Allowing an image upload service.
Would it be possible to allow the users on my site to upload images through an upload script?
-Allowing a donations page. The PHP software I am developing will be open-source and free. Is it
possible for me to add a "Donations" page to my site, to help us to make the software development an
easier process? -Google AdSense. Is AdSense banned on Trap17, or can I add my AdSense code to the
site? -IPB hosting. Is it against the TOS to host paid forum softwares? If I purchase one a....
Difference Between Men And Women.. Funny Pic. Lol
Man and woman was given a task. See how they differ in accomplishing t (3) ....
Vietnam/iraq
Some care to enlighten me on the difference? (10) During the entire war with Iraq, there has been a tremendous outpouring of support for our troops.
There are groups that organize letter drives, packages, and I even saw a bit on TV the other day
about a Music company that is sending guitars over the the boys. Almost every car you see has a
"Support Our Troops" ribbon on it. Seems as though every community has it's own little project
going to show support for our military. And when a fighting man or woman finally gets to come home,
the whole town seems to turn out, with fanfare, bands, news media, the whole ball....
Attraction: The Difference Between The Sexes
(8) After reading several sob stories and pleas for advice from other posts on this forum, I thought I
might share some of my experiences and knowledge. Though I've had my fair share of
relationships, I also like to people watch and I always seem to be the friend that everyone turns to
when they need a shoulder to cry on. It's interesting what you can learn just by watching other
people. First of all, you have to accept the fact that men and women are, for the most part, wired
differently. There are exceptions to the rule, as always, and it's not clear whether th....
Mysql And Sql
difference??? (7) I was wondering what is the difference between MySQL and SQL. I was really confused when i planned
to do a project recently. This question has haunted me for a long time. Is it both same?....
Photoshop Cs2 & Photoshop Cs3
What's the difference (4) I already have the Photoshop CS2 installed on my computer and I'm worried if there great new
things in PS CS3 ... is there a big difference? I don't want to miss new features .. will I
upgrade or buy a new license? /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
alt="sad.gif" />....
Ubuntu Or Kubuntu
What is the difference (8) There are several Linux distros but now the most sought after are Ubuntu and kubuntu. I have used
Ubuntu but not Kubuntu. All I wanted to know is whether there is difference between these two
distros other than the colour of the GUI. If there are any users who have used both of them, could
you please help me out?....
Php Version Difference Error
(1) hi, i had a site which had php coded in earlier version of php ,and gence i feel i am facing errors
like DB Error: unknown errorDB_Error Object ( => => 16 => 1024 => -1
=> DB Error: unknown error => select count(*) from osdate_views_winks where userid =
'143' and act_time > '1174236810' and act = 'V' => Array (
=> Array ( =>
/home/richie/public_html/libs/Pear/DB.php => 748 =>
PEAR_Error ....
What Is The Difference...?
Between bandwidth and webspace? (6) ok what is the big difference betweed space and bandwidth?? it is pretty confusing to me...thanks
for answering /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif"
/>....
The Difference Between Mysql And Postgresql ?
(4) I found those two in cPanel and they loofed nearly the same as each other but what is the difference
? I tried to go to phpMyAdmin and phpPgAdmin and they are nearly the same too. Do you know that ?
Please reply , thanks a lot.....
Java Helpdesk
All your queries regarding Java Programming goes here. (8) Hellow friends, I am creating this thread for all queries and suggestions related to java coding. If
you face any problem, post it here, and others who have a solution can post the reply here. Hope it
helps the users.....
Difference Between Canadians And Americans
topic title explains everything (9) I AM AMERICAN Wassup... I'm not particularly intelligent, open-minded, or well-liked. And I
don't live in a safe place, eat a balanced diet, or drive very well. I don't know
Shakespeare, Da Vinci or Gutenberg,although I'm pretty sure they were American. I drink beer,
not water, I am outspoken, not opinionated, Guns settle disputes, not discussions. Winning isn't
everything, it's the ONLY thing, And it's pronounced RUFF, not ROOF. I can proudly sew my
country's flag on my backpack, unless I go somewhere. Burger King IS fine dining. Wash....
Difference Between The 2005 Ps3 And The New 2006 Ps3
(5) It looks like the PS3 is being fully displayed by sony. The original 2005 desgin had no holes for
the hot air from the processor to come out so the a change in the 2006 model is just a lot fo vents
and holes to let all the hot air out. Some plugs like usb were swiched around and change but for the
most part its the same thing. there will be a 20GB for $499 and 60GB for $599, but it
looks like the 20GB has a lot of setbacks and missing features that the 60GB has. One that i know is
that you will have to use a wired controller for the 20GB.....
Too Many Mysql Queries?
is it bad? (1) I know that querying the database multiple times in a script is bad, because it uses bandwidth. But
what if you have practically unlimited? If you have too, is it ok to have many queries in one
script?....
What's The Difference - Sub-domain With Parked Domain Name And Just Domain Name?
a part of options when Trap17 hosting is created (5) What's the difference between a hosted subdomain with a parked domain from changing a subdomain
to a domain? I'm confused on that. I have my domain parked on my subdomain and it's working
fine but I see people changing their subdomain to a domain? Topic title modified. ....
The Difference Between Cms And Portal?
Expalin this one (0) I have been askign myself this for a long time. And I still have no idea what the difference is. I
get the gist of both of them, but they seem awfully similar. ....
Difference Between Love And Crush
(12) As the title says, i wanna see what all of you out there think the difference between a crush and
true love is i'm 16, and havent seen much of life, but i think i have the general gist of the
difference. This happens so because of my own relationship with a girl, which hasnt gone well, i
wrote this story in the topic named Confusing girls, but it didnt work out, and usually for me, if
it was a crush i would've forgotten a girl in a month or two, but this girl, even though i tried
to avoid for a 3 months after she said no, and staying away, not even seeing her fa....
Difference Between College And University
Does anybody know the difference? (15) Since I'm still in junior high, I don't have to worry about this yet, but could somebody
tell me what the difference between college and university is? And how could people stand going
through college and university?....
What Is The Main Difference Between Religions?
(10) Well, I think that all the religions of the world share a few similar and most important
concepts! There is no religion that would try to convince that doing BAD is acctually good and
vice-versa. I think the main difference is in the word that is used for some sort of divine being
(god, pure good, alah, whatever u name it...) that represents the highest good to all of them. I
think that a mountain is a very good example to explain how these religions are connected: There are
inumerable ways to the top of the mountain and each of this ways is a certain religion but al....
What Is The Difference Between Asp And Php?
How About u ? (3) What is the difference between ASP and PHP? Which language is better? Which is more popular? Which
is more easier to learn? Plz Tell Me More and More information I know PHP is better but i want to
know how you think ! /blink.gif' border='0' style='vertical-align:middle' alt='blink.gif' />
Thanks....
Difference Between C, C++ And C#?
And some other questions. (7) What's the difference between C, C++ and C#? What is more closely related to working with
ASP.NET, C++, C#, or VB? Which comiler is best for C++ and/or C#? Are there any benefits in choosing
VB over C++ or C#? Z^ivjo HR....
Looking for difference, 2, queries
|
|
Searching Video's for difference, 2, queries
|
advertisement
|
|
