ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> password & security
http://www.istechforum.com/YaBB.pl?num=1197643719

Message started by deburr on 12/14/07 at 07:48:39

Title: password & security
Post by deburr on 12/14/07 at 07:48:39

I am still using Crystal 5.0 (which works great for me) but I want to allow some other users to use the program as well. The problem is I don't want to give access to all my data. What is the best way to limit access to specific data files without interfering with the normal operation of DBA/EVO?

Title: Re: password & security
Post by JNAPIER on 12/14/07 at 14:42:43

If you want this user to create reports, they will have acess to all tables. The security in pervasive is to password protect an entire DSN and not at a file by file basis. If you want them to just view and refresh reports, you can make the report executable in a viewer only type thing.

John

Title: Re: password & security
Post by kevind on 12/16/07 at 09:19:13

I password protected the dsn and assigned a simple user name and password. I did not assign any permissions to this user.

Then, in the PUBLIC user, I only selected tables I wanted access too. You can select what type of access you want to each individual table.
I choose select only access.

The user I defined inherits the permissions of public.

You could just as easily add another user for confidential information that has permissions for the additional tables that they need.
You could also define groups that have permissions to different tables that you can assign users too.

Since I am the only one that does any manipulation of the ODBC data, I just use the master user that gets defined when you turn on security.

Title: Re: password & security
Post by deburr on 12/31/07 at 10:21:35

Thanks. This is beyond my experience, but I think I understand and I'll give it a try.