That's almost all I ever use too, (cval('netuser')). I've never used cfg files
for that.
I have a couple installations where there is a general windows logon just to
boot the computer up, and then multiple people will use that machine. In those
cases I will institute a log on / password routine within RBase, compared to a
table that holds the list.
Karen
-----Original Message-----
From: Dan Goldberg <[email protected]>
To: rbase-l <[email protected]>
Sent: Mon, Aug 6, 2018 8:33 am
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE
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
From:[email protected] [mailto:[email protected]]On Behalf Of
Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: [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] <[email protected]>On Behalf Of Albert
Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: [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]> 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]] On Behalf Of
Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
To: [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] <[email protected]> On Behalf Of Jim
Belisle
Sent: Saturday, August 4, 2018 9:43 AM
To: [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.
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.
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.
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].
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.
--
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
[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
[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.
--
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.
