This topic is locked

Adding Multiple Logins On A Live Database

7/6/2018 9:46:10 PM
PHPRunner General questions
R
RockyMtnHi author

I have an existing PHP Runner v9.8 (Build 29909 x64) application that is live and our company uses it every day to run our operations. It has only one login (my lack of foresight), and now we need to add multiple logins, groups and permissions. Since it is live and we run our business with it I can't make mistakes and lock everyone out for long periods of time.
I'm wondering what is the safest route to adding this individual login capability without taking the system down and requiring me to work around the clock to bring it up so our company doesn't freeze during that downtime. I'm paranoid.
I'm asking for guidance and tips that will help me avoid problems and downtime. I can just do it outright, but I thought I'd mine the community experience before I plowed ahead.
If you have done this before then let me know your thoughts. Any and all ideas and input are greatly appreciated.
Thanks for your time.

HJB 7/7/2018

https://xlinesoft.com/phprunner/docs/dynamic_permissions.htm and https://xlinesoft.com/phprunner/docs/user_group_permissions.htm refer here ...
... switching from STATIC to DYNAMIC user permissions for e.g. training and testing under a copy of your project within a local host oriented environment like XAMPP or similar would definitely result in lesser mishaps after having gone live.

admin 7/8/2018

You will need to switch to database-based login, create a copy of your database and fully test your new app using this database copy. Once it is proven to work as expected you need to upload new PHP files replacing old ones and at the same time run a SQL script that would add new tables to your live database or modify existing tables.