topic star in section access in QlikView

star in section access

krishna20 — Thu, 09 Jun 2016 08:24:20 GMT

Hi Friends,

in section access for user

instead of giving all programs can I make it star ?

ACCESS	USERID	PROGRAM	PMT
ADMIN	RGEETHAL	STAR	STAR
USER	RMURUG19	B479_CE1_A_Line	PMT1 - Body Exterior
USER	RMURUG19	B479_CE1_2017MY	PMT1 - Body Exterior
USER	RMURUG19	B479_CE1_A_Line_T	PMT1 - Body Exterior

INSTEAD OF GIVING LISKE THIS

is this possible?

ACCESS	USERID	PROGRAM	PMT
ADMIN	RGEETHAL	STAR	STAR
USER	RMURUG19	STAR	PMT1 - Body Exterior

Re: star in section access

Anil_Babu_Samineni — Thu, 09 Jun 2016 08:30:11 GMT

Krishna,

Might be this is possible.

Please change the STAR instead of ALL and then try. Refresh now and check the live..

Re: star in section access

PrashantSangle — Thu, 09 Jun 2016 08:49:19 GMT

Hi,

Yes you can.

Yo can also kept column blank, to give permission to value inside that column

For more details go through below thread

Section Access

Various levels of security implementation using Section Access

Regards,

Re: star in section access

krishna20 — Thu, 09 Jun 2016 09:03:21 GMT

Thanks for Reply

can you please share script and sample application

Re: star in section access

krishna20 — Thu, 09 Jun 2016 09:09:49 GMT

Hai

Thanks for reply

if user logged into app he want see all program with pmt1

Re: star in section access

PrashantSangle — Thu, 09 Jun 2016 09:16:33 GMT

Hi,

try below

LOAD * INLINE [

ACCESS,USERID,PROGRAM,PMT

ADMIN,ADMIN,,

ADMIN,USER1,,PMT1

];

Regards

Re: star in section access

krishna20 — Thu, 09 Jun 2016 09:18:56 GMT

Hi Max,

assume this is my sample data

PRODUCT

REGION

VPC

EAST

VPC

WEST

VPC

SOUTH

VPC

NORTH

VPCV

EAST

VPCV

WEST

VPCV

SOUTH

VPCV

NORTH

VMC

EAST

VMC

WEST

VMC

SOUTH

USERID	PRODUCT	REGION
ADMIN	STAR	STAR
USERID	ALL PRODUCTS	EAST

WITH OUT ENTERING MANUVAALY ALL THE PRODUCT I WANT JUST PUT STAR ARE SOMETHING

CAN YOU PLEASE REPLY

Re: star in section access

fashid — Thu, 09 Jun 2016 09:22:56 GMT

Dont not type STAR but type ' * ' no quotes

Re: star in section access

Anil_Babu_Samineni — Thu, 09 Jun 2016 10:06:33 GMT

In my section access i am using * and ALL for accessing...

I never used before STAR. Is this STAR is same functionality of * / ALL

Re: star in section access

krishna20 — Thu, 09 Jun 2016 11:04:53 GMT

I have changed still I am getting same problem

Re: star in section access

Anil_Babu_Samineni — Thu, 09 Jun 2016 11:08:15 GMT

Is there any chance to share the qvw with credentials.

Re: star in section access

krishna20 — Thu, 09 Jun 2016 11:47:30 GMT

can you pls share your gmail

I will share all the details

Thakns

Re: star in section access

Anil_Babu_Samineni — Thu, 09 Jun 2016 12:40:19 GMT

I am not more expert.

Is there any problem to share on community. If yes, Please connect to my user and then send me one message so that i will send you the my Email ID,,

Re: star in section access

krishna20 — Thu, 09 Jun 2016 13:04:20 GMT

yes

in my local pc I don't have qlikview

so I am unable to share the application

Re: star in section access

PrashantSangle — Thu, 09 Jun 2016 13:09:33 GMT

Hi,

try below

LOAD * INLINE [

ACCESS,USERID,PRODUCT,REGION

ADMIN,ADMIN,,

ADMIN,USER1,,EAST

];

Regards

Re: star in section access

Anonymous — Thu, 09 Jun 2016 13:13:50 GMT

Use * if you want the user to have access to everything you have defined in the section access table.

Use '' if you want the user (or admin) to have access to everything defined in the sections access table, and in addition any other value that might be added in this field.

I'm not sure I understand what you want to restrict here. If the User should see everything, isn't that the same access level as the Admin?

Re: star in section access

krishna20 — Thu, 09 Jun 2016 13:54:51 GMT

PRODUCT

REGION

VPC

EAST

VPC

WEST

VPC

SOUTH

VPC

NORTH

VPCV

EAST

VPCV

WEST

VPCV

SOUTH

VPCV

NORTH

VMC

EAST

VMC

WEST

VMC

SOUTH

USERID	PRODUCT	REGION
ADMIN	STAR	STAR
USERID	ALL PRODUCTS	EAST

Thanks for Reply

for admin I have all access all product and all regions

but as user I want see all products for east region

so I put star in product for user and I put east in region

but its not working for me

when I put star its showing all the data

Re: star in section access

Anonymous — Thu, 09 Jun 2016 14:07:53 GMT

Then I think you should include Region instead of Program in the Section Access table. Like this:

Load * Inline [

USERID, ACCESS, REGION

ADMIN, ADMIN, ''

USER, USER, EAST

];

(2 single quotes after the ADMIN, ADMIN).

Provided that your connections are right, the User should see all the products but only those associated with Region East. Hope this works.