2. PHPRunner General questions
  3. user permissions
This topic is locked

user permissions

 		4/29/2008 6:59:10 PM
PHPRunner General questions
M
 mrjtdude author

I have two tables:

userpass and data
Master:

userpass table:

user

pass

email
Details:

data table:

First Name

Last Name

Company Name

Company Address

Company Phone

Company Email

Comments
Currently permission are set as follows:

Login Page:

radio button selected: Username and passwords from database

table: userpass

usernamefield: user

password field: pass
====================================
advance button:

current table: data

radio button selected: users can see and edit other users data
current table: userpass

radio button selected: :users can see and edit other users data
I have set static permissions:

username: jack has only view and export selected

username: admin has all selected
======================================
Problem: Assigning permissions to users so they can only view THEIR company data and not other users company data.
I want admin to be the only one who can add,

edit, delete to all users company data
how do i get admin to add,edit,delte these records so that the users can see their own records without having to view everyone elses records?
I have assigned no primary keys in mysql since i have assigned master and details via phprunner...(not sure i understand Primary key fully yet)
any insight would be HIGHLY appreciated. I think I'm about to go nuts trying to figure this all out....
im new to this so forgive me if i come accross sounding like a moron

Respectful regards to whomever can help me out,

mrjtdude
J
 		Jane 4/30/2008

Hi,
there are some tips:

  1. add new field to the company table where login user name will be stored.

    Select User can see and edit their own records only security method and choose this field as OwnerID on the Advanced security settings dialog on the Security tab.
  2. create custom view of company table on the Datasource tables tab for admin account only, select User can see and edit other users data security method for this view and check permissions for this view for admin only on the User group permissions dialog on the Security tab.
M
 		mrjtdude author 4/30/2008

Hi,

there are some tips:

  1. add new field to the company table where login user name will be stored.

    Select User can see and edit their own records only security method and choose this field as OwnerID on the Advanced security settings dialog on the Security tab.
  2. create custom view of company table on the Datasource tables tab for admin account only, select User can see and edit other users data security method for this view and check permissions for this view for admin only on the User group permissions dialog on the Security tab.


Thanks for the quick reply but I figured it all out last night....Man was I happy...need to make a new field for all tables....my tables have changed from 2 to 6 and have them all linked properly with the correct keys and master detail relationships...plus added the checkbox i did not see before to my admin user...awsome software is all i have to say.....you guys were insightful to create such an outstanding product....
regards to all,

mrjtdude

:-) !!!!