aeonflux2
asked on
Restrict View to author
I have a new database and I would like to do the following:
1. Author opens and completes a form.
2. Once completed and saved, if the author goes back into the database, they will open it to see a "main view". The main view will list only the forms that the author created.
Example. Jack Smith completes the form, goes back into the database and can only see and open Jack Smith's forms listed in the view, not Sally Bass's forms, or John Doe's forms. Also, the admin would need a view to see everyones forms listed and be able to open them all as well.
Do I need to use an ACL role?
Do I need to do something to the view to restrict access to author/admin?
Do I need to do something to the form to restrict access to author/admin?
1. Author opens and completes a form.
2. Once completed and saved, if the author goes back into the database, they will open it to see a "main view". The main view will list only the forms that the author created.
Example. Jack Smith completes the form, goes back into the database and can only see and open Jack Smith's forms listed in the view, not Sally Bass's forms, or John Doe's forms. Also, the admin would need a view to see everyones forms listed and be able to open them all as well.
Do I need to use an ACL role?
Do I need to do something to the view to restrict access to author/admin?
Do I need to do something to the form to restrict access to author/admin?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By the way, the UniversalReader role is just for safety, in case the reader leaves the company or loses his password. Nobody would be able to see the document any more. The Manager role is required when you want to replicate the databases with other servers: even servers cannot read documents they cannot access due to insufficient reader permissions. Give the servers the Manager role as well, so they can replicate everything.
ASKER
Thanks!
> Do I need to use an ACL role?
No.
> Do I need to do something to the view to restrict access to author/admin?
No.
> Do I need to do something to the form to restrict access to author/admin?
No.
Guess again! ;-)