Title
limiting user view of a layout while still having full access
Post
I am working on a database where I have a strange problem. I have a user who needs one login that has full access to all tables and layouts. Then another that has full access to everything but viewing a certain layout.. I know that I can go to manage security and create custom privileges, but it seems to limit the access to a certain layout would also mean all options to access data from that layout would be removed as well. it's normally would not be a problem if the user was operating from a computer, however it's going to be on an iPad so just limiting the views of certain layouts and allowing another account to have full access to open any view in design mode wouldn't work. I am hopeful that there is a script that could just hide a layout from the layout selection. Currently my layouts are selected from a value list so if there is a way to pick the value list basee on user name that would work too....
To repeat: you have complete control over what layouts are listed in that drop down. There's a check box in Manage | Layouts and also in Layout Setup... for controlling which layouts are listed in that drop down.
This is not the case. The key phrase is "via this layout". If you restrict them from the layout then then cannot access the data in that table via this layout. They can still access the data in the table from a different layout unless you specifically block access to the Table.
But if this is just to keep customers who borrow your client's iPad from accessing or knowing about that data while they use it for a few minutes, you may not need to use access privileges. You may be able to control it with the design your layouts/scripts etc.