Sorry - thought you did - no offense intended - should be in the manual. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, October 18, 2010 5:53 PM To: U2 Users List Subject: Re: [U2] CREATE.TRIGGER - Permission denied
Dave, If I had access to Unidata, I'd do HELP CREATE.TRIGGER, but I don't. I thought I could learn something for future reference. Sorry I wasted your bandwidth. Charlie Charlie Noah Charles W. Noah Associates cwn...@comcast.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 10-18-2010 3:31 PM, Dave Davis wrote: > HELP CREATE.TRIGGER explains the rules. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah > Sent: Monday, October 18, 2010 4:19 PM > To: U2 Users List > Subject: Re: [U2] CREATE.TRIGGER - Permission denied > > Sorry - I misread. However, even if it's Unidata, the same question > still applies. There does appear to be some disagreement as to whether > it requires root or just file ownership. What about group? If a user is > in the same group as the file, would that be sufficient (AIX was the > Unix I worked on most)? If so, I don't see a problem with that, since, > depending on the file's permissions, a user probably shouldn't be able > to do much of anything with the file unless he/she owns it or is in the > same group. > > Charlie Noah > Charles W. Noah Associates > cwn...@comcast.net > > The views and opinions expressed herein are my own (Charlie Noah) and do > not necessarily reflect the views, positions or policies of any of my > former, current or future employers, employees, clients, friends, > enemies or anyone else who might take exception to them. > > > On 10-18-2010 1:46 PM, phil walker wrote: >> Universe does not require root access to create a trigger. The article >> refers to Unidata. >> >>> -----Original Message----- >>> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >>> boun...@listserver.u2ug.org] On Behalf Of Charlie Noah >>> Sent: Tuesday, 19 October 2010 7:30 a.m. >>> To: U2 Users List >>> Subject: Re: [U2] CREATE.TRIGGER - Permission denied >>> >>> I have used Jbase for 12 years, and used Universe for many before >> that. I >>> was surprised to learn that Universe requires one to have root access >> to >>> create a trigger. Jbase doesn't require that, so I guess I was >> spoiled. Does >>> anyone know of any compelling reason why Universe would require it? >>> >>> Charlie Noah >>> Charles W. Noah Associates >>> cwn...@comcast.net >>> >>> The views and opinions expressed herein are my own (Charlie Noah) and >> do >>> not necessarily reflect the views, positions or policies of any of my >> former, >>> current or future employers, employees, clients, friends, enemies or >> anyone >>> else who might take exception to them. >>> >>> >>> On 10-18-2010 12:10 PM, Colin Alfke wrote: >>>> As others have noted you need to login as root to create the >> trigger. >>>> We use a program that does the following for each of our triggers >>>> (UniData on Windows with SB+). >>>> >>>> DELETE.TRIGGER filename UPDATE >>>> DELETE.CATALOG triggerprogram >>>> BASIC programfile programname >>>> CATALOG programfile programname FORCE >>>> CREATE.TRIGGER programfile programname UPDATE >>>> >>>> Hth >>>> Colin Alfke >>>> Calgary, Canada >>>> >>>> -----Original Message----- >>>> From: Mecki Foerthmann >>>> >>>> Hi, >>>> >>>> Today I tried for the first time to create a trigger on Unidata >>>> (Version >>>> 5.2 on Solaris) and get this error. >>>> I have to add we are using SB+ and Avante 9.2 which includes PRC >> 3.9. >>>> First time I tried this I actually got an SB+ error (line 200 >>>> something) >>>> - and when I run it from "true" ECL I just get the message >> "PERMISSION >>>> DENIED". >>>> I even changed the LOGIN VOC entry to bypass SB+ - no luck either. >>>> The file in question has 777 permissions on Solaris, so this >> couldn't >>>> be the problem. >>>> The subroutine is globally cataloged too and there are no triggers >> on >>>> the file already. >>>> It isn't a DIR file either. Well, I haven't checked that, but all >> our >>>> data files are hashed. >>>> I'll check it tomorrow morning. >>>> Any ideas? >>>> I know Avante uses triggers for its audit files, so why can't I >> create >>>> my own? >>>> Susan perhaps? Is it your application that stops me? >>>> >>>> Thanks >>>> >>>> Mecki >>>> >>>> _______________________________________________ >>>> U2-Users mailing list >>>> U2-Users@listserver.u2ug.org >>>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>>> >>> _______________________________________________ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > <html> > <body> > ________________________________ Dave Davis Team Lead, R&D P: > 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com > [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] > [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] > 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com > This message is intended exclusively for the individual or entity to which it > is addressed. This communication may contain information that is proprietary, > privileged or confidential > or otherwise legally exempt from disclosure. If you are not the named > addressee, you are not authorized to read, print, retain, copy or disseminate > this message or any part of it. If you have received this message in error, > please notify the sender immediately > by e-mail and delete all copies of the message. > </body> > </html> > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users <html> <body> ________________________________ Dave Davis Team Lead, R&D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. </body> </html> _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users