topic how to get ACL of QVW in QlikView

how to get ACL of QVW

Mon, 08 Aug 2011 04:44:02 GMT

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.

Re: how to get ACL of QVW

Mon, 08 Aug 2011 07:53:29 GMT

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

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....

Re: how to get ACL of QVW

Mon, 08 Aug 2011 13:29:18 GMT

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

here it is..

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

how to get ACL of QVW

Thu, 11 Aug 2011 10:30:26 GMT

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

how to get ACL of QVW

Thu, 11 Aug 2011 11:10:31 GMT

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.

Re: how to get ACL of QVW

IAMDV — Tue, 25 Feb 2014 11:23:41 GMT

Hi Nick,

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

Thanks,

Re: how to get ACL of QVW

Anonymous — Tue, 25 Nov 2014 14:32:59 GMT

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.