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

[kismet_1]

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

[Karl Rohwedder]

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

[Uwe Zessin]

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

[Antoniov.]

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

[Ian Miller.]

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

[Mobeen_1]

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

[Joseph Huber_1 · Accepted solution]

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 !

[kismet_1]

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