[Resolved] Query help

PyroX

Hey all.

Basically, I have something that can have recursive permissions. Call it a user for simplicity. SO you tell the user that they can access a url recursivley. But then you want to add a rule that says this one item in that path they cannot access.

So, in code it would look something like:

if(notExplicitlyBanned($exactPath) && allowedByRecursive($parent)
{

}

How would I do this in sql?

I can ask ( QUERY ) the table:

(item,path,access,recursive)

If access is not allowed, but it's parent's permissions are recursive, it should not show up.

Right now, it tests false for allowed, but since it reads it's parent is recursive, it goes on and allows it.

I don't want to do more than one query here.

This is all pretty cryptic, can anyone follow me here, and help?

tomhath

You need to think through the question you're asking, and ask it in terms other people will understand. Recursive permissions? What are those? I've heard of inherited permissions, but recursive is a new one.

You say you have a table with three columns. But then you say want to "ask the table" about four things. What do you mean by "ask the table"? That makes no sense at all. And does your table have three columns or four columns?

😕 😕 😕

PyroX

I am just having it run a 2nd query when it comes accross recursive permissions.

What are recursive permissions?
it means apply to all sub items in this case.
If you used Linux I would think you would know.
For example: rm -Rf dirname is a recursive delete.

-r, -R, --recursive
remove the contents of directories recursively

A little common sense is required.

que·ry ( P ) Pronunciation Key (kwîr)
n. pl. que·ries

A question; an inquiry. To Ask

So when I say "To ask" obviously I mean query.

While I admit the entire post was a bit confusing, your little rant did not help me.

Thanks for wasting both our time!