RE: [RBASE-L] - using user IDs and passwords for RBASE

[Buddy Walker]

Jim

  As you can see from Dan and Karen’s response there are a number of ways to 
achieve a login.

 

   Whichever way you decide to go if you have any questions just ask.

 

Buddy

 

 

From: karentellef via RBASE-L  
Sent: Monday, August 6, 2018 9:46 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE

 

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 mailto:d...@lancecamper.com> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
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: rbase-l@googlegroups.com   
mailto:l...@googlegroups.com> > On Behalf Of Jim 
Belisle
Sent: Monday, August 6, 2018 4:41 AM
To: rbase-l@googlegroups.com  
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: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: rbase-l@googlegroups.com  
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: rbase-l@googlegroups.com   
mailto:rbase-l@googlegroups.com> > On Behalf Of 
Albert Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com  
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 mailto:j...@kaypark.com> > 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



 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
To: rbase-l@googlegroups.com  
Subject: RE: [RBASE-L] - using user IDs and 

Re: [RBASE-L] - using user IDs and passwords for RBASE

[karentellef via RBASE-L]

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 
To: rbase-l 
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: rbase-l@googlegroups.com On Behalf Of Jim 
Belisle
Sent: Monday, August 6, 2018 4:41 AM
To: rbase-l@googlegroups.com
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:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: rbase-l@googlegroups.com
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: rbase-l@googlegroups.com On Behalf Of Albert 
Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com
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  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




 


From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
To: rbase-l@googlegroups.com
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: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Saturday, August 4, 2018 9:43 AM
To: rbase-l@googlegroups.com
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 

RE: [RBASE-L] - using user IDs and passwords for RBASE

[Dan Goldberg]

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: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Monday, August 6, 2018 4:41 AM
To: rbase-l@googlegroups.com
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:image001.jpg@01CD8CE2.FB048F50]

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: rbase-l@googlegroups.com
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: rbase-l@googlegroups.com 
mailto:rbase-l@googlegroups.com>> On Behalf Of Albert 
Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com
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 
mailto:j...@kaypark.com>> 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


From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
To: rbase-l@googlegroups.com
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: rbase-l@googlegroups.com 
mailto:rbase-l@googlegroups.com>> On Behalf Of Jim 
Belisle
Sent: Saturday, August 4, 2018 9:43 AM
To: rbase-l@googlegroups.com
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 

RE: [RBASE-L] - using user IDs and passwords for RBASE

[Jim Belisle]

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:image001.jpg@01CD8CE2.FB048F50]

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: rbase-l@googlegroups.com
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: rbase-l@googlegroups.com  On Behalf Of Albert 
Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com
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 
mailto:j...@kaypark.com>> 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


From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
To: rbase-l@googlegroups.com
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: rbase-l@googlegroups.com 
mailto:rbase-l@googlegroups.com>> On Behalf Of Jim 
Belisle
Sent: Saturday, August 4, 2018 9:43 AM
To: rbase-l@googlegroups.com
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


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You