DB Access Log

HCL Domino Domino Forum
1

Dear all,

Good day to all of you.

I was asked to implement a function which will capture user who access to the DB.

I am using LS to trigger this function and it is placed in the Postopen section of database Script.

This function will write user name together with date into one of the database form.

The problem come in when my user are not all given authority to write / update document.

Please advice what can i do in this situation.

Many many thakns in advance.

2

Subject: DB Access Log

You can allow users who only have read access to a database to create a document by making the form available to public access users. Enable the read and write public access settings in tha ACL. The following is from the notes help

To designate a page, form, or subform for public access

  1. Open the page, form, or subform.

  2. Choose Design - Properties.

  3. Click the Security tab.

  4. Select “Available to Public Access Users.”

  5. On a form or subform, create a field.

  6. In the Name field, enter $PublicAccess.

  7. In the Type field, select Text and Computed when composed.

  8. In the Programmer’s pane at the bottom of the form, enter “1” as the default value for the field.

  9. To hide this field from users, select the Field Hide When tab and specify hide-when conditions.

3

Subject: RE: DB Access Log

Hi Matt,

Thanks for your guide. Now managed to let user with Readers access (with Write public document box checked).

Beside this method, is there any way to allow with reader access to write into public document without needing to check the “Write public document” box?

Cheers,

John

4

Subject: RE: DB Access Log

This is the only way to allow people with reader access to edit documents. It is perfectly secure as they can only edit those documents that you explicitly mark as available to public access users in the form properties.

5

Subject: RE: DB Access Log

Hi Matt,

Okidoki and thank you very much for your feedback.

Cheers,

John