Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Table1:
Customer,Country,Period,Publish
A,Germany,2005,1
B,Italy,2005,1
C,Iraq,2005,0
SectionAccess:
NTName,Access,Country,Period,Flag
Alfred,Admin,<ANY>,2005,1
Jerald,Admin,Iraq,2005,1
Jack,USer,Iraq,2005,0
My requirement is, i want Jerald to see 2005 related data for Iraq but Jack should not see it.
I wish to control it from the Table1 on field Publish.
If i make Publish column 1 then Jack and Jerald both should see it.
How can i achieve this?
In terms of business I want to release the data in the dashboard but Jerald see it first and once he approves over email
i will make publish column 1 so that Jack,Jerald or whoever have access to Iraq, irrespective of flag value either 0/1
should see it.
can anyone help?
I think this way it may work -
1. Keep duplicate entries for Mgmt people having 0,1 both in Publish flag, like below -
Section Access;
LOAD * INLINE [
ACCESS,USERID,PUBLISH
ADMIN,ALFRED,1
ADMIN,JERALD,1
ADMIN,ALFRED,0
ADMIN,JERALD,0
USER,JACK,0
];
2. Now when new year data is published, keep flag value as 1, so that only Mgmt people can see the data, as below -
Section Application;
Table1:
LOAD * INLINE [
Customer,COUNTRY,Period,PUBLISH
A,Germany,2005,0
B,Italy,2005,0
C,Iraq,2005,0
D,Germany,2006,0
E,Italy,2006,0
F,Iraq,2006,0
G,Germany,2006,1
H,Italy,2006,1
I,Iraq,2006,1
];
3. When Mgmt guys are ok with the data change flag value to 0 so that both Mgmt and Users can see the data, as below -
Section Application;
Table1:
LOAD * INLINE [
Customer,COUNTRY,Period,PUBLISH
A,Germany,2005,0
B,Italy,2005,0
C,Iraq,2005,0
D,Germany,2006,0
E,Italy,2006,0
F,Iraq,2006,0
G,Germany,2006,0
H,Italy,2006,0
I,Iraq,2006,0
];
By mistake highlighted entries showing 2006, it should be 2007 to reflect new year.
Thanks,
But duplicate in section access wont cause access issue?
I don't think so, we are not changing credential, we are just providing additional data access.
Gautham,
Did you solve the issue, If yes, Close this Thread Or else get a chance to look this
http://www.qknow.com.br/wiki/index.php/Section_Access_(English)
- Anil Chowdary