topic Re: very funny!A sql program is executed ,but no any files is producted in Operating System - OpenVMS

very funny!A sql program is executed ,but no any files is producted

kismet_1 — Mon, 06 Jun 2005 02:36:20 GMT

I've a order directory,the protection and ACL is the followwing:
Protection: (System: RWE, Owner: RWE, Group: RWED, World: RWED)
Access Control List:
(IDENTIFIER=[210,*],ACCESS=READ+WRITE+EXECUTE+DELETE)

Howerver,the protection and ACL that executed SQL programe "order_abnormal.sql" is the followwing:
File protection: System:RWED, Owner:RWED, Group:RE, World:RWED
Access Cntrl List: (IDENTIFIER=[210,*],ACCESS=READ+WRITE+EXECUTE+DELETE)

Why only the user that he've "ALL" privs can excute it and product required file?Other user is not excute it when you used the followwing command:
sqlplus @order_abnormal

Re: very funny!A sql program is executed ,but no any files is producted

Karl Rohwedder — Mon, 06 Jun 2005 03:06:26 GMT

Kismet,

there must be a 'real' errormessage, pls. post it.

The SQL procudure is run against a database (RDB/Oracle?) This db must have a protection scheme, which may restrict the access.
In case of RDB this may be viewed with e.g.:

$ rmu/sh priv 'database'

regards Kalle

Re: very funny!A sql program is executed ,but no any files is producted

Uwe Zessin — Mon, 06 Jun 2005 03:33:09 GMT

kismet,

I suggest that you also check all directories on the path of the output directory. E.g.

[ABC.DEF]O.LIS

check:
- [000000]000000.DIR;1

(needs at least W:E)

- [000000]ABC.DIR;1
- [ABC]DEF.DIR;1

Re: very funny!A sql program is executed ,but no any files is producted

Antoniov. — Mon, 06 Jun 2005 05:21:13 GMT

I noticed file sql has RE priv for group user. I know this is not important but it's a clue for your trouble. Perhaps, your folder may have same protectin schema so application can't write new files.
I know it's strange but it is the only clue I've seen.

Antonio Vigliotti

Re: very funny!A sql program is executed ,but no any files is producted

Ian Miller. — Mon, 06 Jun 2005 05:50:08 GMT

If its VMS protection problem then enable audit for file access failure and that should give you some more information.

SET AUDIT/AUDIT/ENABLE=FILE=FAILURE

Re: very funny!A sql program is executed ,but no any files is producted

Mobeen_1 — Mon, 06 Jun 2005 06:10:31 GMT

Kismet,
I think you should go with Ian's suggestion and enable audit on file failures.

Once you execute the command given by Ian, then if you do the following

$reply/enable

Now when you execute the command, if there is any failure in creating the file when executing the sql file, then you will see that its reported on the OPCOMS on your screen.

If you see such message and have no clue on what that is, please post it here and we would be able to figure it out for you and give appropiate advise

regards
Mobeen

Re: very funny!A sql program is executed ,but no any files is producted

Joseph Huber_1 — Mon, 06 Jun 2005 07:14:55 GMT

What is the content of order_abnormal.sql ?
Which file(-name) does/should it produce ?
Is a file with the same name already existing in the directory, but with a protection which does not allow overriding/creating a new version of it ?
Your ACLs specify Delete access for the DIRECTORY, not a default ACL for the FILES IN the directory !

Re: very funny!A sql program is executed ,but no any files is producted

kismet_1 — Mon, 06 Jun 2005 20:40:24 GMT

I'm very sorry for later replying!It've solved!The real reason is just what Joseph Huber is saied aboveâ â There is a file with the same name already existing in the directory, but with a protection which does not allow overriding/creating a new version of