Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Database security
To whom it may concern:
I am now in trial period of online real estate database evaluation hosted by your company, I have one question, is it possible I can share the database to my company staff while they can not just export, copy, backup the database? Thank you for your attention.

Regards,

Benjamin X
ID
722
Category
User Experience
Author

Benjamin X
Date Created
2/13/2014 9:46:10 PM
Date Updated
8/29/2014 1:45:26 PM
Comments
Benjamin X 2/13/2014 9:50:09 PM
A few more details, my question was made because the database will contain all house owners contact details which is valuable information according to the local market practice.
Benjamin X 2/13/2014 9:54:31 PM
And it is my understanding that a database shared to staffs can not definitely keep staffs from copying the database, it is just that I hope it won't happen too easy, anyway, if there is a precaution design/function/solution related to my concern, it will be appreciated if you can share with me.
Nathan Phillips (CW) 2/13/2014 11:14:42 PM
Benjamin,

There are 3 things to watch for here.

1) Give users NO setup access. Setup access gives the ability to export all data in a table. You control this when adding new users to your application.

2) Hide the Print/Export/Send buttons on ALL tables. This is done in Table properties when you create the table. There's a User Interface section where you can edit this.

You probably want to create a role that has restricted access, maybe call it Standard User. Then Hide Print/Export/Send on ALL tables for that role. And every time you add a new user to your application, give them the Standard User role.

3) You can also restrict the maximum number of records that a view will show to users. You do this in the View properties when you create the view. So you can, ie show users a maximum of 15 records at a time, and make them search for the data they want. This way you're never giving them a huge chunk of data on any single page.

The way to do this is probably to create special views specifically for the restricted Standard User role. And make sure that role ONLY has access to those special, restricted views. This way you can have views accessible to other roles, ie application administrators, that can see more data when necessary.
Benjamin X 2/13/2014 11:24:47 PM
Nathan,
Thank you for your quick reply, I will read it through closely and probably try to run the suggested methods and see how they work with my company practice before my next question.
Regards,
Admin Support 8/29/2014 1:10:02 PM
Hi Nathan,

Where do I go to find the "User interface section"? I have searched through my options and cannot seem to find where I can hide Print/Export/Send.

Just like Ben this is a big issue for us, we hold a lot of valuable information in our system and don't want certain user types to have that ability to export our data.
Nathan Phillips (CW) 8/29/2014 1:45:26 PM
Hi,

If you go to the Setup in your database, then open the table you want, in the Table section you have a "Table properties" link. If you open that link you get to the table properties page.

On that page there's a User Interface section, it actually has a set of different UI elements you can hide. One of the things you can hide is the Print/Export/Send buttons.

Hope that helps! - Nathan
Feedback
Back to Search Results