2. PHPRunner General questions
  3. [SOLVED]  Set permissions in existent database
This topic is locked
[SOLVED]

 Set permissions in existent database

 		4/4/2011 11:58:15 AM
PHPRunner General questions
Z
 zeth385 author

Well, I have this database created since 2009. Everything was working just fine, but now, my boss asked me to set permissions to users, since many of them have deleted or edited other users data. The way users access to this database is by a username and a password stored into a table. I've tried the option "users can see and edit their own data only" (adding a username field on the data table), but, as I assumed, the old data is not longer visible. Users can only see and edit only new records. This is a problem, since they edit and see old data stored. I am affraid that the only way I can manage this, is by adding the user that created the record manually... but is a LOT of info... so, Hope you can help me.
Thanks in advance.
P
 		procheck 4/4/2011

You're going to need to set something up as described in this link:
http://www.asprunner.com/forums/topic/16669-advanced-security-options/pagefromsearch1
Sergey Kornilov admin 4/5/2011

If you want to use "users can see and edit their own data only" security mode you must populate OwnerID field of data table with ID of the user who "owns" this record. That's the only way to make it work.
Z
 		zeth385 author 4/5/2011



If you want to use "users can see and edit their own data only" security mode you must populate OwnerID field of data table with ID of the user who "owns" this record. That's the only way to make it work.


Ouch...!!! well... if there's no other way... I'll have to start now... 'Cause I've tried the above method, but nothing worked.... Anyway... thanks for your help, both of you!
Sergey Kornilov admin 4/5/2011

Probably you can provide a more detailed description than "nothing worked". It's not clear what exactly causes the trouble.
You can also post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
Z
 		zeth385 author 4/5/2011



Probably you can provide a more detailed description than "nothing worked". It's not clear what exactly causes the trouble.
You can also post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.


Oh, sorry for not being clear... I've tried the method described on prochecksports' post, but didn't do what I wanted... so I tried yours, and it's working so far. Sorry for the misunderstanding.