Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

berndjaegle
Contributor

Export Section Access to QVD

How can I Export Section Access Table to a qvd?

Thnx,

Bernd

1 Solution

Accepted Solutions
berndjaegle
Contributor

Re: Export Section Access to QVD

Following works for me:

Create Tmp Table with Section Access Information.

Export table as QVD(!) and reload the QVD with "where 1=1"

tmp_SectionAccess:

LOAD * INLINE [
     ACCESS, USERID, PASSWORD, NTNAME

     ADMIN, admin, 1234, *
     USER, user, , *    

     USER, test, test, MS\SCOTT];

tmp_SectionAccess into TmpSectionAccess.qvd (qvd);

drop Table tmp_SectionAccess ;

SECTION Access;
   LOAD
    
ACCESS,
    
USERID,
    
PASSWORD,
    
NTNAME
FROM
Tmp_SectionAccess.qvd (
qvd)
WHERE 1=1;

3 Replies

Re: Export Section Access to QVD

Couldn't you simply use:

store SectionAccess into SectionAccess.qvd (qvd);

- Marcus

berndjaegle
Contributor

Re: Export Section Access to QVD

2016-08-12 11_43_15-Script Execution Progress.png

was not successful.

berndjaegle
Contributor

Re: Export Section Access to QVD

Following works for me:

Create Tmp Table with Section Access Information.

Export table as QVD(!) and reload the QVD with "where 1=1"

tmp_SectionAccess:

LOAD * INLINE [
     ACCESS, USERID, PASSWORD, NTNAME

     ADMIN, admin, 1234, *
     USER, user, , *    

     USER, test, test, MS\SCOTT];

tmp_SectionAccess into TmpSectionAccess.qvd (qvd);

drop Table tmp_SectionAccess ;

SECTION Access;
   LOAD
    
ACCESS,
    
USERID,
    
PASSWORD,
    
NTNAME
FROM
Tmp_SectionAccess.qvd (
qvd)
WHERE 1=1;

Community Browser