topic Re: Remove Deleted User's Access in QlikView

Remove Deleted User's Access

Mon, 26 Jan 2026 18:19:17 GMT

I'm using DMS and I've deleted some of the users, but the document authorization was not removed. Is there a way to clean this up other than going to each document and remove it?

Re: Remove Deleted User's Access

prieper — Fri, 27 Mar 2015 08:59:19 GMT

no,

you may use in future a central script to administer all apps and users

Peter

Re: Remove Deleted User's Access

Mon, 30 Mar 2015 02:49:45 GMT

What kind of script that we can use in the future? Can elaborate more?

Thanks...

Re: Remove Deleted User's Access

prieper — Mon, 30 Mar 2015 07:56:20 GMT

We are using a crosstable (in Excel) with the users on the left side, the application-name on the right and an identifyer, whether the user is allowed to access

Then with a script like

LET sFile = CHR(39) & UPPER(DocumentName) & CHR(39); // current filename in Apostrophs

SECTION ACCESS;

UsersAll: CROSSTABLE (FileName, AccessAllowed) LOAD * FROM ....; // Load entire data

Users: LOAD 'USER' AS ACCESS, UserName WHERE AccessAllowed = 'Y' AND MATCH(FileName, $(sFile)); // Select only users being allowed the access for this particular app.

SECTION APPLICATION;

Typically we have stored the above in a textscript and insert in each application only the line

// ==========================================================Access-Part

$(Include=\\......\qv-security$\QV Access Script.txt);

// ===========================================================Script-Part

edit: we usually use NT-names, which makes the identification even easier.

HTH Peter

Re: Remove Deleted User's Access

Tue, 19 May 2015 03:23:52 GMT

Thanks for the information. But some of our apps have their own section access as well. Not sure if this will complicate thing further.

Re: Remove Deleted User's Access

Bill_Britt — Tue, 19 May 2015 14:33:44 GMT

Hi,

It is best to try to use groups to manage users. That way you don't have to edit the scripts when users change.

Bill