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
