Remove Deleted User's Access

[#1]

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?

[prieper]

no,

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

Peter

[#3]

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

Thanks...

[prieper]

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

[#5]

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

[Bill_Britt]

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