Re: [U2] CREATE.TRIGGER - Permission denied
Charlie, in the end I had to execute !sudo chown username filename before I could successfully create the trigger. So you don't have to be logged on as root. I don't know about the group. If I would have to do this more often I would just write my own routine in Basic and place it in the VOC. But maybe it's just how our Solaris system (or my profile) is set up. Mecki On 19/10/2010 22:22, Charlie Noah wrote: > No problem, Dave. I would still like to get a clarification from > those in the know of how Universe and Unidata handle this issue, > though. For instance: > Do they require root access? > If not, do they require you to be the file owner? > Is being in the same group as the file sufficient? It was when I used > Jbase on AIX. > Is Windows any different than Unix? > Are there configuration settings that affect this other than file > permissions? > > I don't have an immediate need, but this is all good knowledge to tuck > away for the future. > > Thanks, > 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-19-2010 8:54 AM, Dave Davis wrote: >> 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
Re: [U2] CREATE.TRIGGER - Permission denied
> No problem, Dave. I would still like to get a clarification from those >in the know of how Universe and Unidata handle this issue, though. On UD 7.1 / AIX 5.3 I have to be the owner to do a CREATE-TRIGGER, even if the file privs are 777. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CREATE.TRIGGER - Permission denied
No problem, Dave. I would still like to get a clarification from those in the know of how Universe and Unidata handle this issue, though. For instance: Do they require root access? If not, do they require you to be the file owner? Is being in the same group as the file sufficient? It was when I used Jbase on AIX. Is Windows any different than Unix? Are there configuration settings that affect this other than file permissions? I don't have an immediate need, but this is all good knowledge to tuck away for the future. Thanks, 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-19-2010 8:54 AM, Dave Davis wrote: 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 s
Re: [U2] CREATE.TRIGGER - Permission denied
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 qu
Re: [U2] CREATE.TRIGGER - Permission denied
Hi Susan, I get the error on the CREATE.TRIGGER command. I guess it has something to do with writing to the "file header". This part is not very well explained in the Using UniData manual - well not at all really. It just says that the trigger is written to the file header and even that it may sometimes be necessary to edit the file header manually, but where this file header can be found isn't explained at all. The only reference to a file header in the whole manual is in the trigger section. Probably it is another Unix "feature" and requires ownership or root privileges and not just read, write and execute permissions. I've been caught out a few times with those "undocumented features" after creating or resizing files from static hashed to dynamic in UD and forgetting to do a chmod 777 in Unix afterwards. If I still have problems tomorrow I'll contact you directly Mecki On 18/10/2010 20:28, Susan Joslyn wrote: > Hi Mecki, > > I don't think PRC is in your way, but I would never say "never".When do > you get the PERMISSION DENIED error, when you go to edit the triggered file > and make a change and file it? Or when? > > I use triggers in an SB+ enabled account on Unidata, so I don't think SB+ is > getting in your way either. > > > > I can look at it with you, if you want - contact me directly. > > > > Regards, > > Susan Joslyn > > sjos...@sjplus.com > > PRCR Real IT Governance for U2. > > > > > > Date: Mon, 18 Oct 2010 17:07:17 +0100 > > From: Mecki Foerthmann > > To: U2 Users List > > Subject: [U2] CREATE.TRIGGER - Permission denied > > Message-ID: <4cbc70b5.8030...@gmx.net> > > Content-Type: text/plain; charset=ISO-8859-1 > > > > 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
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 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/im
Re: [U2] CREATE.TRIGGER - Permission denied
LOL No, I guess there are other companies as well that are a bit paranoid in that regard. I was told it has something to do with the auditors insisting on that policy. Supposedly if you use sudo it gets logged but if you log in as root you can screw the system and nobody is any the wiser. But since there is only UD running on the server and I am also the UD admin it is stupid really. I can't even log users off or release locks using UVAdmin. But if ownership is sufficient I can change that with sudo and back again after the trigger is created. Mecki On 18/10/2010 19:34, Laura Wright wrote: > You don't work at Lee Brass Company do you??? > > Laura > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CREATE.TRIGGER - Permission denied
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 > __
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
[U2] CREATE.TRIGGER - Permission denied
Hi Mecki, I don't think PRC is in your way, but I would never say "never".When do you get the PERMISSION DENIED error, when you go to edit the triggered file and make a change and file it? Or when? I use triggers in an SB+ enabled account on Unidata, so I don't think SB+ is getting in your way either. I can look at it with you, if you want - contact me directly. Regards, Susan Joslyn sjos...@sjplus.com PRCR Real IT Governance for U2. Date: Mon, 18 Oct 2010 17:07:17 +0100 From: Mecki Foerthmann To: U2 Users List Subject: [U2] CREATE.TRIGGER - Permission denied Message-ID: <4cbc70b5.8030...@gmx.net> Content-Type: text/plain; charset=ISO-8859-1 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
Re: [U2] CREATE.TRIGGER - Permission denied
Unidata does not require you to be root. Just that the person creating the trigger owns the file. We use triggers here all the time and never become root to create or remove. The key is being the owner of the file. -Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Monday, October 18, 2010 2:47 PM To: U2 Users List Subject: Re: [U2] CREATE.TRIGGER - Permission denied 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
Re: [U2] CREATE.TRIGGER - Permission denied
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
Re: [U2] CREATE.TRIGGER - Permission denied
You don't work at Lee Brass Company do you??? Laura -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, October 18, 2010 2:18 PM To: U2 Users List Subject: Re: [U2] CREATE.TRIGGER - Permission denied Thanks everybody, They should have really pointed that out in the UniData manual. Can you do this somehow using sudo since my network administrator is very concerned about giving anybody the root password? I'll try again tomorrow. cheers Mecki On 18/10/2010 18:10, 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 -- This message has been scanned for viruses and dangerous content by SecureMail, and is believed to be clean. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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
Re: [U2] CREATE.TRIGGER - Permission denied
Thanks everybody, They should have really pointed that out in the UniData manual. Can you do this somehow using sudo since my network administrator is very concerned about giving anybody the root password? I'll try again tomorrow. cheers Mecki On 18/10/2010 18:10, 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
Re: [U2] CREATE.TRIGGER - Permission denied
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
Re: [U2] CREATE.TRIGGER - Permission denied
In order to create a trigger in Unidata the Unix user you are logged in as needs to own the file. -Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, October 18, 2010 12:07 PM To: U2 Users List Subject: [U2] CREATE.TRIGGER - Permission denied 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
Re: [U2] CREATE.TRIGGER - Permission denied
Are you logged in as a root user? You need root permissions to create triggers. Thanks, Steve Long Spyderweb Techincal Services, Inc. (360) 687-8797 Office (866) 354-5913 Fax www.spyderwebtech.net -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, October 18, 2010 9:07 AM To: U2 Users List Subject: [U2] CREATE.TRIGGER - Permission denied 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] CREATE.TRIGGER - Permission denied
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