Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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