This topic is locked

Difference between Advanced security settings and Permissions

10/26/2011 2:20:38 PM
PHPRunner General questions
N
notuo author

Hi. I am lost here. I am trying to set up permissions for a project.
I need Admin, and several other levels of access to the system.
I set up the user/pwd table and also set the permissions for all the levels and tables using the permissions... button.
But,

  1. The menu doesn't reflect anything, ie. all the users see the same menu. Is this correct or do I have to do anything special?
  2. Even I set a restriction for a user not so see nor edit nor nothing a table, the user can do anything on that table. Is this because the "advanced security settings" was left to the defaults?


I don't get the difference or complement or otherwise between those to parts in the security tab in phprunner.
Any comment is really appreciated.
Thanks in advance

P
procheck 10/26/2011

You will need to setup a view of the same table and allow access that way.
For example:
Table A can be set for the users to see columns 1 to 5 but not 6 to 10 and the security/permissions set as needed.
The View can be called something like admin_table A and it can be set specifically for admin with no access for users.

N
notuo author 10/26/2011

Thanks. I did that before ask for help. My problem was not to do a full build. Now is working as I expected.
Anyway, the remaining this is:
What is the purpose of the "advanced" and the "permissions...".
Does one supersede the other?, are complementary? what?
English is not my mother tong, and the manual is not clear to me in this specific part.

Sergey Kornilov admin 10/26/2011

I would suggest watching 'How to use security settings' video at http://xlinesoft.com/phprunner/php-database.htm. Explains the difference between different security settings.

C
cgphp 10/26/2011

Are you using static or dynamic permissions ?

N
notuo author 10/26/2011



I would suggest watching 'How to use security settings' video at http://xlinesoft.com/phprunner/php-database.htm. Explains the difference between different security settings.


Actually Sergey, it doesn't. Simple shows how to use one after another, just like the manual. No difference is shown there from my point of view.



Are you using static or dynamic permissions ?


Static.

Sergey Kornilov admin 10/26/2011

These permissions work independently. Group permissions define actions that are available to each group. Actions are edit, delete, add etc.
Advanced security defines access to specific records in each tables i.e. user can see and edit all records, user can see and edit her own records only etc. Cannot be simpler than that.