I have a routine that sits between our basic menu system and the universe :
prompt thats only allows users access to certain commands (like SELECT LIST)
but does not allow them access to others (like DELETE) would you like a copy ?
Bob
-Original Message-
From: [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong
Sent: Thursday, October 27, 2005 10:32 PM
To: U2-Users New Lists
Subject: [U2] To Limit TCL Access Privilege
Dear All
I am trying to give some user to have privilege to access to
From: John Jenkins [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Friday, October 28, 2005 7:28 AM
Subject: RE: [U2] To Limit TCL Access Privilege
Take a look at remote verbs - these are ideal for what you want to
achieve.
Essentially, you change the VOC entries of key verbs to R
Flag every shipment as Residential and then when the shipment is a
Business you get a rebate and avoid any fines.
It's much better getting a check back then having to pay extra fee's
plus fines.
Jeffrey Lettau
ERP Systems Manager
polkaudio
-Original Message-
From: [EMAIL
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
** A week is defined as a seven-day period running from Monday-Sunday.
** Week 1 of any year is defined as the first week containing four days
** of the year, or equivalently the week containing the first Wednesday
** of the year. For
Does anyone know if there is built-in functionality in UniVerse to
convert a date and time to UTC? I look through conversion codes and
cannot seem to find anything there. Any ideas?
Thanks.
Perry Taylor
Zirmed, Inc.
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
In regards to determining how many sessions a user has you can view all
of the sessions by enter PORT.STATUS at the TCL line or use Universe
Administration tool to view all processes on the system, You can also
limit
the number of Universe session for a users, you may want to review the
Universe
Thanks to someone whose message I deleted, I now know that (in Unidata, at
least), there are two ways to do this:
:ESEARCH filename
STRING :
will get you all the records that have a double quote anywhere in the record.
:SELECT filename WITH EVAL 'COUNT(fieldname,CHAR(34))' GE 1
will get
quote who=Allen Egerton
From: John Jenkins [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Friday, October 28, 2005 7:28 AM
Subject: RE: [U2] To Limit TCL Access Privilege
Take a look at remote verbs - these are ideal for what you want to
achieve.
Essentially, you change the VOC
Does anyone know if there is built-in functionality in UniVerse to
convert a date and time to UTC? I look through conversion codes and
cannot seem to find anything there. Any ideas?
Conversion or the current value? .. The current value (in seconds) is UV
SYSTEM(99)
To convert DATE() /
Hi,
I know this may have discussed before but has anyone developed a VB
interface between SQL Server and UV.
Any ideas are most welcome.
Thanks in advance...
R,
Sunny
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I posted earlier than in UD the following doesn't work (you get a syntax
error):
SELECT filename WITH fieldname = '[]'
but it turns out that wasn't quite accurate. 'Tis true when ECLTYPE='p',
which is our setting, so I tried:
select filename WITH fieldname = '[]'
which worked.
You could also do the record level search with the following EVAL...
LIST filename WITH EVAL INDEX(@RECORD,CHAR(34),1) GT 0
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Tymoczko
Sent: Friday, October 28, 2005 9:00 AM
To:
Samba is probably not the issue. Although you *may* have to fiddle with the
samba config to get the results you want, depending on what you are trying
to do.
All samba does is make a unix filesystem available to DOS/Windows as if it
were native. When reading via samba, it just serves up the
Have you been using PostNuke all this time? And if so, can you share what
exploits with the PostNuke Security group so the rest of us can harden our
PostNuke sites??
And moreover, what is it that is making u2ug.org more likely to be hacked -
security patch issues? Random hackers? Or is someone
Hi Craig,
We are in the process of archiving our invoices. What we do is to
create select lists for each year that we want to archive. One list for
delivered sales and one for cancelled sales. We have a program that we
run, which we have tailored to ask for the name of the select list to
use,
Yuck!!!
- read about Security routines in the UV System Description manual
- write a security routine(s) to allow/deny access per user, per group,
whatever
- create a file which has the 'R'emote verbs with security routine(s)
specified
- copy those verbs over the user VOC after every
If by worked you mean the statement didn't give you any syntax errors.
When using the u-type parser the syntax for the select is different.
This won't find a field with a double quote in it, it will find one
where the field IS actually [].
Hth
Colin Alfke
-Original Message-
From:
What syntax is used to manipulate or select from a Unidata file's
dictionary via ODBC?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Keith W. Roberts
Sent: 28 October 2005 16:17
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] To Limit TCL Access Privilege
Yuck!!!
- read about Security routines in the UV System
You need to define a schema. This converts dictionary items and file
names to valid SQL names and puts it in the files so that the ODBC
connector will use them. It can also setup permissions and views to
normalize the data for the ODBC calls.
The easiest way to do this is through the Visual
The efficiency of the PDF has a lot to do with the tools used to generate
them, which you didn't mention here (htmldoc, ps2pdf, etc). Some
commandline tools for PDF include some form of compression argument. There
are tools available to optimize PDF in *nix, rather than going through the
export
Sunny Matharoo wrote:
I know this may have discussed before but has anyone
developed a VB interface between SQL Server and UV.
This would be pretty easy to do with mv.NET using ADO.NET as the common
medium. What's on your mind, maybe I can whip something up. The solution
would depend a lot
Sorry, I didn't actually construct matching data to check it. :)
I see you are right. I tried using:
select filename WITH fieldname = '..'
but the ellipses, which cause it to do pattern matching, apparently also
cause it to look for an included string enclosed by , with no way to
I apologize to everyone for the post about PDF. I used the wrong to
address. I think I've done this before. I suspect I will be banned
from the list. This was meant for Craig Bennet. I will try not to do
this again.
My apologies
Anthony
---
u2-users mailing list
I think the original message was sent to the incorrect address. Craig's
company writes a PDF generation program in U2 basic. I'm guessing it
should have been sent directly to them.
See: http://cross.net.au/pdf.asp
Colin Alfke
-Original Message-
From: Tony Gravagno
The efficiency of
Wol:
As Kevin alluded to earlier, the program, and the consequences you point
out, are exactly what the client wanted. So much for standards. :-)
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, October 28,
Original Message
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Simon Carter
Sent: Friday, October 28, 2005 9:28 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] To Limit TCL Access Privilege
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
I understand defining a schema, but what if you need to interact with
the dictionary of a file as if it were the data part of the file? I
can setup a schema for a file, which will let me see the data in that
file, but what if I want to return a list of dictionary names?
-Original
Tony Gravagno wrote:
John Hester wrote:
Has anyone directly integrated UPS's online shipping rate
calculator service and/or address verification with UV?
http://www.ups.com/content/us/en/bussol/offering/technology/automated_ship
ping/online_tools.html
The FAQ has good info. Web Services
Karjala Koponen wrote:
Is this something that can be done with the U2 SOAP API as written up by Nik
Kesic of IBM at
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0508kesic/ ?
The link came from the U2UG site.
Thanks, looks like that will be a good place to start.
-John
--
Do you use Wintegrate?
I have my users use Query Builder instead of TCL.
-Original Message-
From: Ang Suan Yong [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 27, 2005 9:32 PM
To: U2-Users New Lists
Subject: [U2] To Limit TCL Access Privilege
Dear All
I am trying to give
David,
These are 'Script Kiddie hacks. A Script Kiddie is someone who
knows nothing about hacking and cracking, they just know how to download
software that is pre-written to do vandalism. So we seem to be a random
target. I would guess both attacks were from the same limited
individual.
On UniVerse you can use the Remote Command Entry to provide security on
verbs, procs, paragraphs, etc.
Copy the verbs you wish to protect into a file such as the VOCLIB file.
Then create a remote command entry in the VOC.
The remote command has a structure of:
ID = name of the command (i.e.
If you are running in pick flavor then you will need to use eval. If
you create an entry in the VOC like this (which is the IDEAL flavor
version of LIST)-
LIST2
0001 V
0002 LIST
0003 Q
0004 GHS
Then you can do
LIST2 VOC WITH F2 LIKE '..'
Or
LIST2 VOC WITH F2 LIKE '0X0X'
Hope that
Results wrote:
- Chuck If I Only I Could Hack Sites While Knowing
Nothing, And With No Regard For Others, I Could Be Cool
Like Them Barouch
Hey bro, ya gotta admit these kiddies were quick enough to execute the
exploit before you professionals could update the server against it. Let
this
We're coming from DG/UX and have used for years SH -c 'kermit -s
whateverfile.name' inside a VOC to get our files from Unix to our local PC.
Is there anything simular to this in the Windows 2003 Server and Universe
that we can automate from the VOC's then the user just click FileDownload
on their
I rather enjoyed it. :) A little cross-pollination doesn't hurt.
-Keith
Original Message
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Anthony Dzikiewicz
Sent: Friday, October 28, 2005 10:59 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] PDF Efficiency
I
I suppose you could always create a file pointer to D_filename with
DICT.DICT as it's dictionary, and then create the schema from there.
Although DICT.DICT for UD is rather primitive. I've added some
i-descriptors to mine. Don't forget to use READDICT.DICT if you do the
same.
-Keith
Sunny,
SM I know this may have discussed before but has anyone developed a VB
SM interface between SQL Server and UV.
what kind of 'interface' are you looking for? UV has a connection
that works well with SqlServer so possibly before we get a lot of code
generated you describe better what
40 matches
Mail list logo
