Document in Database Access Control

Chris_m used Ask the Experts™
We are using LN 6.5
Is it possible to restrict access to documents in a databse view to only those documents created by the person who is logged on (ie, without specifically creating a view for each person who has the right to create documents.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi Chris_m,
one way is to create Form with one hidden field and embedded view.
    - computed
    - formula: @Name([CN]; @Username)
    - create the view which suites your purpose and when you're done insert the new first column, which should be categorized and contain formula: @Name([CN]; @Author)
    - property Show single category: name of your hidden field

Hope this helps,
Sjef BosmanGroupware Consultant

Hello Chris_m,

Yes, you can do that. Each document would need a Readers field with only those who should be able to read the document.

Top Expert 2007

You should read up on reader- author fields so that you do not end up locking yourself out of the documents.

You should alwasy include an author field giving Admin access.

I hope this helps !

Whoops, sysExpert, I think you meant to say, "you should always include an Admin role or Group in the Readers field - so you and the server don't get locked out of the documents"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial