Section Access control using flag

[gauthamchilled]

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?

[Digvijay_Singh]

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

];

[Digvijay_Singh]

By mistake highlighted entries showing 2006, it should be 2007 to reflect new year.

[gauthamchilled]

Thanks,

But duplicate in section access wont cause access issue?

[Digvijay_Singh]

I don't think so, we are not changing credential, we are just providing additional data access.

[Anil_Babu_Samineni]

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