Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to get ACL of QVW

Hi All,

Does anyone know if there's a way to retrieve the ACL info of a QVW file ?

what i'm trying to do is to retrieve the ACL info or user name of a selected QVW and display it.

Could be use for administration.

Any tips?

Thanks.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: how to get ACL of QVW

ok, if anyone is looking for the answer...

here it is..

http://community.qlik.com/docs/DOC-2293

6 Replies
Not applicable

Re: how to get ACL of QVW

Ok, after one day of googling..

found this easy script generator - http://www.vbsedit.com/scripts/security/dacls/scr_1384.asp

to get file's DACLS.

' Read a File DACL

strFileName = "C:\tt.txt"

SE_DACL_PRESENT = &h4

ACCESS_ALLOWED_ACE_TYPE = &h0

ACCESS_DENIED_ACE_TYPE  = &h1

FILE_ALL_ACCESS       = &h1f01ff

FILE_APPEND_DATA      = &h000004

FILE_DELETE           = &h010000

FILE_DELETE_CHILD     = &h000040

FILE_EXECUTE          = &h000020

FILE_READ_ATTRIBUTES  = &h000080

FILE_READ_CONTROL     = &h020000

FILE_READ_DATA        = &h000001

FILE_READ_EA          = &h000008

FILE_SYNCHRONIZE      = &h100000

FILE_WRITE_ATTRIBUTES = &h000100

FILE_WRITE_DAC        = &h040000

FILE_WRITE_DATA       = &h000002

FILE_WRITE_EA         = &h000010

FILE_WRITE_OWNER      = &h080000

Set objWMIService = GetObject("winmgmts:")

Set objFileSecuritySettings = _

objWMIService.Get("Win32_LogicalFileSecuritySetting='" & strFileName & "'")

intRetVal = objFileSecuritySettings.GetSecurityDescriptor(objSD)

intControlFlags = objSD.ControlFlags

If intControlFlags AND SE_DACL_PRESENT Then

   arrACEs = objSD.DACL

   For Each objACE in arrACEs

      WScript.Echo objACE.Trustee.Domain & "\" & objACE.Trustee.Name

   Next

Else

   WScript.Echo "No DACL present in security descriptor"

End If

if someone can help to "embeded" into QV, to retrieve multiple QVWs, that'd be super nice !

meanwhile, i'm trying....

Not applicable

Re: how to get ACL of QVW

ok, if anyone is looking for the answer...

here it is..

http://community.qlik.com/docs/DOC-2293

Not applicable

how to get ACL of QVW

Hi, Im trying to get the file size from an Excel file with a macro or when loading the initial script. I tried your code but VBScript compiler doesnt recognize some things...

Could you please help me?

Thanks in advance

Not applicable

how to get ACL of QVW

Hey, I discovered how to do it with Qlikview functions.

I added this code to my script to load the data from the DataBase:

LET Mantra_report.csv_size=FileSize('R:\New Operations\OnMark\DataFiles\Mantra_report.csv');

LET revenue.csv_time=FileTime('R:\New Operations\OnMark\DataFiles\revenue.csv');

Regards.

IAMDV
Honored Contributor II

Re: how to get ACL of QVW

Hi Nick,

Please can you point us to the answer or new thread. The old thread is not working!

Thanks,

DV

qlikdash
Contributor II

Re: how to get ACL of QVW

when I try to go to this link, http://community.qlik.com/docs/DOC-2293

I get the following error message.

Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

Can someone advice me.

Community Browser