ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Limiting access to tables
http://www.istechforum.com/YaBB.pl?num=1361044885

Message started by David Waldmann on 02/16/13 at 13:01:25

Title: Limiting access to tables
Post by David Waldmann on 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,

Title: Re: Limiting access to tables
Post by kevind on 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 (http://www.istechsupport.com/bugtrack/view.php?id=264)enhacement request on Mantis.

Title: Re: Limiting access to tables
Post by David Waldmann on 02/18/13 at 13:45:47

Kevin,

Thanks for the info and warning :)

-d

Title: Re: Limiting access to tables
Post by David Waldmann on 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.

Title: Re: Limiting access to tables
Post by kevind on 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.

Title: Re: Limiting access to tables
Post by David Waldmann on 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!

Title: Re: Limiting access to tables
Post by kevind on 02/20/13 at 13:37:25

I try. ( my wife says I'm 'Trying' ;) )