Welcome, Guest. Please Login.
03/28/24 at 21:57:51
News:
Home Help Search Login


Pages: 1
Send Topic Print
Limiting access to tables (Read 2396 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Limiting access to tables
02/16/13 at 13:01:25
 
Is there any feasible way to limit access to certain tables (i.e. Payroll related) via CR?
 
I plan to add an employee to help with our IT stuff and one of the duties will be report creation/maintenance in CR, but I don't want them to be able to access PR stuff at least, and possibly some other financial data.
 
TIA,
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: Limiting access to tables
Reply #1 - 02/18/13 at 13:34:05
 
David,
It is possible to limit what individual users can access through ODBC.
 
You do this by enabling Security from within the Pervasive Control Center.
When you enable security, you assign a password to the 'Master' user.
The Master user has access to all tables.
 
DO NOT FORGET THIS PASSWORD!  
 
From that point, you can Add a user and click checkboxes next to the 'select' operation for
tables that you want them to access.
 
I set up a generic user called 'dba' with checkboxes next to only the tables that my
CR reports need access to.
 
When CR refreshes a report, it will prompt for a username and password.
 
Here's the problem:
 
If you use JDBC access from EVO, you cannot secure your DDF files

 
That's why I submited THIS enhacement request on Mantis.
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Limiting access to tables
Reply #2 - 02/18/13 at 13:45:47
 
Kevin,
 
Thanks for the info and warning Smiley
 
-d
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Limiting access to tables
Reply #3 - 02/19/13 at 05:51:32
 
For the lower access users can you have a username with a blank password?
 
Also, once you set up security, can you remove it? Our regular users (non report developers) use DataLink Viewer to view and refresh reports, and I'm concerned that if we set up security there's a chance that DataLink Viewer won't know how to handle it. Or is it just a function of the ODBC client?
 
Thanks again.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: Limiting access to tables
Reply #4 - 02/19/13 at 12:24:01
 
David,
I can speak with regard to Pervasive 2000i in this regard.  
I had to put a password on the 'dba' user I defined.  I just used 'dba'.
 
You can turn off security.  It will just ask you for the Master password when you do.
 
When you enable Security, a user named PUBLIC gets created (that has no password)
You could just enable the tables you want everyone access under this user.
When an app asks for a username and password, enter PUBLIC for the username and leave the password blank.
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Limiting access to tables
Reply #5 - 02/19/13 at 14:11:42
 
This is very helpful, Kevin.  
Since it sounds like security can be pretty easily turned on and off maybe we will go ahead with it, and I'll just turn it off when I need to use JDBC and then back on when I'm done.
Thanks a lot!
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: Limiting access to tables
Reply #6 - 02/20/13 at 13:37:25
 
I try.  ( my wife says I'm 'Trying'   Wink )
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1
Send Topic Print