pcsoft.us.windevCopyright 2026, PC SOFT14 Nov 2014 12:01:00 Z14 Nov 2014 05:55:00 ZDear All, In a software that I am developing I am using web service to access remote database which is MySQL. As I am not using the native HFSQL Classic or Server it would not be possible to implement Groupware for user access rights management. To handle users and their access rights here is what I am doing: I have create three tables Table 1 is Privilege master (priv) Table 2 is User master (usr) Table 3 is User Privilege (usrpriv) Here are the structure of these tables as dumped by MySQL phpMyAdmin: -- -- Table structure for table `priv` -- CREATE TABLE IF NOT EXISTS `priv` ( `priv_id` int(11) NOT NULL AUTO_INCREMENT, `priv_module` text, `priv_name` text, `priv_descrip` text, PRIMARY KEY (`priv_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `usr` -- CREATE TABLE IF NOT EXISTS `usr` ( `usr_id` int(11) NOT NULL AUTO_INCREMENT, `usr_username` text, `usr_propername` text, `usr_passwd` text, `usr_initials` text, `usr_active` tinyint(1) NOT NULL DEFAULT '1', `usr_email` text, PRIMARY KEY (`usr_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `usrpriv` -- CREATE TABLE IF NOT EXISTS `usrpriv` ( `usrpriv_id` int(11) NOT NULL AUTO_INCREMENT, `usrpriv_priv_id` int(11) DEFAULT NULL, `usrpriv_usr_id` int(11) DEFAULT NULL, PRIMARY KEY (`usrpriv_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; What I am planning to do is enter all the features that are necessary for the users in the priv table taking care to note down the automatically generated RecID (priv_id). Then in a Global module I am creating constants names as per user rights name and assigning them value as per the auto generated RecID. Now when a user is assigned an access right I am saving the same info in usrpriv table. When a user logs in and tries to access any part of the software I will first check whether the user has the required rights (in usrpriv table) to access that part of the software or not and then allow access or deny access. What I am doing seems to work at experimental level. I would like to know if this is the right way to go? Another thing is that this way is quite laborious as I have always keep the priv table and my list of constants in sync. Is there any easier way to manage user access rights then this that anyone has been using successfully and would like to share please to share it here? TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48949-need-advise-wd17-user-access-management/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48949-need-advise-wd17-user-access-management-48960/read.awp14 Nov 2014 12:01:00 ZHi there are many different ways to manage that problem. You can by example add a PROFILE functionality, in order to save man…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48949-need-advise-wd17-user-access-management-48960/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48949-need-advise-wd17-user-access-management-48960/read.awpNeed Advise WD17 - User Access Managementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48949-need-advise-wd17-user-access-management-48959/read.awp14 Nov 2014 11:57:00 ZYogi First thing I would suggest is that you use InnoDB as your database engine and not MyISAM especially if data integrity i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48949-need-advise-wd17-user-access-management-48959/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48949-need-advise-wd17-user-access-management-48959/read.awpNeed Advise WD17 - User Access Management