Section Access through Database

[victor5995]

Hi Folks,

I have requirement to implement section access through database user table that contain USERID. I have to set up this in a way that all the user within this table should able to access the application.

Appreciate any help.....

Thanks

[jagan]

Hi,

Try like this

Section Access;

SQL SELECT

USERID,

PASSWORD,

'USER' AS ACCESS

FROM TableName;

Section Application;

star is *;

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

If you don't have password then try this

Hi,

Try like this

Section Access;

SQL SELECT

USERID,

'USER' AS ACCESS

FROM TableName;

Section Application;

star is *;

Hope this helps you.

Regards,

Jagan.

[victor5995]

Hi Jagan.

Thanks for your quick response.

It is working as intended but by doing this I think all have access as USER only. If I want to give some one ADMIN as access then how can I do that?

Again Thanks.

[datagrrl]

I have a user SQL table that doesn't include my service accounts or developer ID. I load an inline table first then my SQL table.

I do mine like this:

LOAD * INLINE [
USERID, ACCESS

,DOMAIN\ADMIN,ADMIN];

Ideally I would probably write a view with a union statement to pull my admin accounts, as that seems easier to maintain but this solution works.

[victor5995]

Hi,

I have exact same situation that you described like the database table do not contain the Developer ID's.

I am using the code provided by Jagan Mohan above. Please let me know with that where I can add the inline table which contain the Developer ID's.

Code :

Section Access;

SQL SELECT

USERID,

'USER' AS ACCESS

FROM TableName;

Section Application;

star is *;

Thanks

[victor5995]

I Solved it by concatenating main USER table with inline table of Developer's ID.

But one step further now I have to reduce the data according to databases. Here all data including user info coming from different databases so if some USERID is existed in particular database then that user should see only data associated with that database only. I have the key here that representing the different database of user but I am not getting how can I implement that key in section access.

Appreciate any Help.

Thanks.

[datagrrl]

Section Access;
SA_Table:
LOAD * INLINE[
USERID,ACCESS
ADMIN,ADMIN
SVC1,ADMIN
];

SA_Table:
SQL SELECT

USERID,

'USER' AS ACCESS

FROM TableName;

[victor5995]

But here how can I reduce the data ?

[datagrrl]

I used this blog to figure somethig similar out:

http://www.resultdata.com/qlikview-section-access-and-document-authorization/