Mapping all id's to admin using section access

[rsdhavle]

I have one table containing multiple ids

I have defined section access table in which i have entry as

NTName   ID    ACCESS

A               *     ADMIN

B               12    USER

C               114    USER

Now I am joining this section table with my main table containing multiple Ids on a field ID but when NTNAME A user logins who has admin privilages he is able to see only two ids defined in section access table that 12 and 114.. Why is that?

Am i missing on anything or join is incorrect?

[jonathandienst]

Hi

* used like this means all the other defined values, as you have observed. You will need define the other values in some way. For example, create a dummy user with NONE for Access and one line for each of the IDs.

NTNAME, ID, ACCESS

Dummy, 1, NONE

Dummy, 2, NONE

...

Or else in your load script, translate the * line into one line per ID for the ADMIN user.

NTNAME, ID,  ACCESS

A, 1, ADMIN

A, 2, ADMIN

...

HTH

Jonathan