AnsweredAssumed Answered

limiting user view of a layout while still having full access

Question asked by MichaelLawrence on Sep 26, 2013
Latest reply on Sep 27, 2013 by philmodjunk

Like • Show 0 Likes0
Comment • 9

Title

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....

philmodjunk Sep 27, 2013 6:48 AM

Correct Answer

The layouts on an iPad are all accessed from a dropdown box using a value list of 'Customers, Products, Invoices'.

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.

if I select 'no access' to this layout, then it also means no access to the records there.

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.

See the reply in context

No one else had this question

Outcomes

philmodjunk Sep 26, 2013 5:03 PM

Why can't you just set up a privilege set with full access to the data but with access blocked to the one layout?

And you can eliminate any layout you want from the layouts drop down by clearing a check box in Layout Setup and also in Manage | Layouts.

Actions

MichaelLawrence Sep 26, 2013 5:23 PM

Is that possible phil i thought that if i limited the 'no access' option for the layout, it greyed out the 'records via this layout' so it would mean that you cant access the data from this table?

Actions

JonJ Sep 27, 2013 4:51 AM

I'm not sure I quite understand your scenario—could you give me a fuller example of what you're trying to achieve? It may be that you need to have two priv sets, and you use a script temporarily re-authenticate your user to view certain layouts...

Actions

philmodjunk Sep 27, 2013 5:47 AM

If you check the settings in Manage | Security, there is one set of settings for the Tables and One for the Layouts.

Actions

MichaelLawrence Sep 27, 2013 6:18 AM

Here is some more info: The user is going to be using his iPad to input records while on the job site. While there he will often be allowing other clients to view the Ipad for confirmation purposes (viewing the invoice before he prints/emails it). He is going to be putting a lot of proprietary information into the 'products' table, which will contain valuable information for his business.

He wishes to have 2 separate logins, one with full access to everything in order to build his product table to contain alot of confidential information that he will be using from home/when he is alone. The other login would have the ability to manipulate data, input records, and have all the same functionality but without the view of the 'product'. He doesn't want the other people handling the iPad to even know that a 'product' table exists.

The layouts on an iPad are all accessed from a dropdown box using a value list of 'Customers, Products, Invoices'.

Actions

MichaelLawrence Sep 27, 2013 6:22 AM

Maybe I'm wrong but it seems like if I select 'no access' to this layout, then it also means no access to the records there. I still want the ability to look at invoice details and not have 'no access' come up for all the product names.

Actions

philmodjunk Sep 27, 2013 6:48 AM

The layouts on an iPad are all accessed from a dropdown box using a value list of 'Customers, Products, Invoices'.

if I select 'no access' to this layout, then it also means no access to the records there.

Actions

MichaelLawrence Sep 27, 2013 7:55 AM

Thanks for the help Phil, I wasn't sure about the 'via this layout' restrictions because I kept getting 'no access' on some of my layouts. I was stupid and still had one of my main layouts accessible but the records listed as 'no access'.

I'm definitely aware that I can go to Manage > Layouts and not allow certain layouts using the checkbox as well as just changing the values in the value list. I just don't see any way of doing that for a specific user/login and keeping it open for everyone else without getting creative with design/scripts like you said.

I think this will definitely work, and the user will probably be nagging 'but I can still see it in the list' even if it doesn't take then anywhere. Oh well I'm content. Thanks everyone

Actions

philmodjunk Sep 27, 2013 3:21 PM

If you hide the tool bar, you can add your own drop down for layout navigation to the layout and the list of layouts in this drop down can be limited to just the layouts permitted for that user. Then the user will not be able to see the layout name if the file is open under the limited access layout. (And you can use Relogin as a quick way to switch automatically form full access to limited access with a single tap of the user's finger.)

Actions

9 Replies

philmodjunk Sep 26, 2013 5:03 PM
Mark Correct
Correct Answer
Why can't you just set up a privilege set with full access to the data but with access blocked to the one layout?

And you can eliminate any layout you want from the layouts drop down by clearing a check box in Layout Setup and also in Manage | Layouts.
Like • Show 0 Likes0
Actions
MichaelLawrence Sep 26, 2013 5:23 PM
Mark Correct
Correct Answer
Is that possible phil i thought that if i limited the 'no access' option for the layout, it greyed out the 'records via this layout' so it would mean that you cant access the data from this table?
Like • Show 0 Likes0
Actions
JonJ Sep 27, 2013 4:51 AM
Mark Correct
Correct Answer
I'm not sure I quite understand your scenario—could you give me a fuller example of what you're trying to achieve? It may be that you need to have two priv sets, and you use a script temporarily re-authenticate your user to view certain layouts...
Like • Show 0 Likes0
Actions
philmodjunk Sep 27, 2013 5:47 AM
Mark Correct
Correct Answer
If you check the settings in Manage | Security, there is one set of settings for the Tables and One for the Layouts.
Like • Show 0 Likes0
Actions
MichaelLawrence Sep 27, 2013 6:18 AM
Mark Correct
Correct Answer
     Here is some more info: The user is going to be using his iPad to input records while on the job site. While there he will often be allowing other clients to view the Ipad for confirmation purposes (viewing the invoice before he prints/emails it). He is going to be putting a lot of proprietary information into the 'products' table, which will contain valuable information for his business.

     He wishes to have 2 separate logins, one with full access to everything in order to build his product table to contain alot of confidential information that he will be using from home/when he is alone. The other login would have the ability to manipulate data, input records, and have all the same functionality but without the view of the 'product'. He doesn't want the other people handling the iPad to even know that a 'product' table exists.

     The layouts on an iPad are all accessed from a dropdown box using a value list of 'Customers, Products, Invoices'.
Like • Show 0 Likes0
Actions
MichaelLawrence Sep 27, 2013 6:22 AM
Mark Correct
Correct Answer
Maybe I'm wrong but it seems like if I select 'no access' to this layout, then it also means no access to the records there. I still want the ability to look at invoice details and not have 'no access' come up for all the product names.
Like • Show 0 Likes0
Actions
philmodjunk Sep 27, 2013 6:48 AM
Unmark Correct
Correct Answer

          The layouts on an iPad are all accessed from a dropdown box using a value list of 'Customers, Products, Invoices'.

     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.


          if I select 'no access' to this layout, then it also means no access to the records there.

     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.
Like • Show 0 Likes0
Actions
MichaelLawrence Sep 27, 2013 7:55 AM
Mark Correct
Correct Answer
     Thanks for the help Phil, I wasn't sure about the 'via this layout' restrictions because I kept getting 'no access' on some of my layouts. I was stupid and still had one of my main layouts accessible but the records listed as 'no access'.

     I'm definitely aware that I can go to Manage > Layouts and not allow certain layouts using the checkbox as well as just changing the values in the value list. I just don't see any way of doing that for a specific user/login and keeping it open for everyone else without getting creative with design/scripts like you said.

     I think this will definitely work, and the user will probably be nagging 'but I can still see it in the list' even if it doesn't take then anywhere. Oh well I'm content. Thanks everyone
Like • Show 0 Likes0
Actions
philmodjunk Sep 27, 2013 3:21 PM
Mark Correct
Correct Answer
If you hide the tool bar, you can add your own drop down for layout navigation to the layout and the list of layouts in this drop down can be limited to just the layouts permitted for that user. Then the user will not be able to see the layout name if the file is open under the limited access layout. (And you can use Relogin as a quick way to switch automatically form full access to limited access with a single tap of the user's finger.)
Like • Show 0 Likes0
Actions

limiting user view of a layout while still having full access

Title

Post

Outcomes

Related Content

Recommended Content