I use the cval(‘netuser’) to authenticate and give permissions from there. I have a table with the users/windows logon names with their access rights. Based on their rights the menu will displayed.
Dan Goldberg From: [email protected] <[email protected]> On Behalf Of Jim Belisle Sent: Monday, August 6, 2018 4:41 AM To: [email protected] Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE Buddy and Albert, Thanks for the information. I am in meetings the first part of the week so will have to wait on this. I am not sure if I mentioned this to you but I am the only one who has a full version of RBASE. I create the compiled application and all others use this application and use the same CFG file on the server. That CFG is located on the server in the same folder as the compiled apps and any DLLS or other programs needed in RBASE. So as you can see, all this is new to me and I am having trouble “connecting the dots”. I will read the RBASE pdfs to see if I can get further understanding on setting up log ins based on users in a compiled app system. I have read this in the past but we did not implement. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Saturday, August 4, 2018 10:40 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE Jim Each user will need there own RBENGINEXE.CFG (RBENGINEX.CFG) file. You would have to visit each user’s PC once and update the RBENGINEXE.CFG (RBENGINEX.CFG) this can be done in couple of different ways: 1. Start a session of R:Base and then select Settings > Configuration Settings > Multi User now in the NAME box type in the users windows/exchange name 2. The other way is edit the file using Notepad or some other text editor. Find the line that starts with NAME and then highlight and replace the name that is there. Now just follow Albert’s example below. Buddy From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Albert Berry Sent: Saturday, August 4, 2018 12:05 PM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE Create a Windows file and add it to the line in the user icon that calls the database. It should read as Buddy suggested. In the icon command line below, I called it DBLogin.dat IF CVAL (‘USER’) <> (‘NETUSER’) THEN PAUSE 2 USING ‘Not Authorized’ EXIT RETURN The icon would read along these lines. The default is RBASE.DAT but I would not recommend that, because that would give you indigestion every time you tried to log into the database. C:\RBTI\RBGXE\RBGXE.exe DBLogin.dat As Razzak would say “That’s all there is to it” Albert On Aug 4, 2018, at 9:16 AM, Jim Belisle <[email protected]<mailto:[email protected]>> wrote: Buddy, Thanks for the response. You are talking to someone who is very ignorant of how to even start down this road. At the present the DB is setup without IDs (USER is NONE) I need to know how to get that setup in the first place. The code set var vu = (CVAL('USER')) gives my NONE as an answer. So I will need to start from the beginning. We are talking about an application in which 12 to 15 users will be accessing the DB. I do not know the passwords for the users. James Belisle Making Information Systems People Friendly Since 1990 <image001.jpg> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Saturday, August 4, 2018 10:02 AM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE Jim Use the CVAL(‘USER’) and CVAL(‘NETUSER’) If CVAL(‘USER’) <> CVAL(‘NETUSER’) THEN PAUSE 2 USI ‘Not Authorized’ EXIT ENDIF Just make sure the CFG name matches the Network User Name. This way you won’t have to worry about R:Base password Windows should handle everything. Buddy From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Jim Belisle Sent: Saturday, August 4, 2018 9:43 AM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - using user IDs and passwords for RBASE We are needing to change our RBASE application so as to require user IDS and passwords. Here is what we want to do. 1. We want the computer login USER and password to be used as the login for RBASE. In other words, I want this to be automatic so the user does not need to fill in their user and password for each session of RBASE. When they log into the computer that information would go into variables and RBASE would see it in either the CFG or DAT file. 1. To possibly complicate matters, out IT has instituted a mandatory password change within a certain time periods (ongoing into the future). Of course the code would have to take password changes into consideration. 1. I noticed in the command pdf there is a WINAUTH command that looks promising, however this is all new to me. I have an idea of what the code would have to do but have never really worked with meshing what Windows “sees” with RBASE. James Belisle Making Information Systems People Friendly Since 1990 <image001.jpg> -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
