× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Thanks Al, what did you mean by enhanced access?  
 
Currently, the usrprf's who are using sequel are *exclude to the files that 
they want to query via SEQUEL and my boss doesn't want to update the 
authorities of the objects so we'll probably use the swapping pgm and I'll let 
you know how that works out.  
 
  
 
 
-----Original Message-----
From: ALopez@xxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Sent: Mon, 8 Jan 2007 1:27 PM
Subject: Re: SEQUEL Authority


I did the equivalent of create a SEQUEL group profile with *USE access to 
the data libraries needed, then the files as needed (both libraries and 
files are *PUBLIC EXCLUDE, with normal users only able to see either by 
programs adopting authority).  Eventually I was forced to a second level 
of access (SEQUEL1) for users with enhanced access.

I have not used (nor was I aware of) a user swapping program within 
SEQUEL.  I had looked at their inclusion/exclusion dictionary, creating my 
own version of SQLXCL02 (the program used to check the dictionary), but 
decided that I prefer having everything built on internal OS/400 
authorities.  In your case, I do wonder if it's worth the trouble to swap 
authorities to another profile vs. using a group profile. A lot would 
depend on whether or not those group profiles that you already use have 
*USE or *CHANGE rights to the files in question.

......

We're on an 810, with perhaps 125 users able to use SEQUEL, about 40 
regular users of the PC interface Viewpoints, maybe 5 active users who 
actually write new views.  We've never had a problem with performance. 
Some of those views go over moderate size files (3 - 5 million records). 
I'd be more worried about users writing run-away views because of poor 
file linking.  That happens about once a quarter and we just kill the 
query and tell them to try again.  You might be able to cut that off by 
using SEQUEL's ability to predefine how files should be linked.  SEQUEL 
can even look over a bunch of your own views and come up with default 
linkings for you. 

 



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.