Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File permission setup including execution

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File permission setup including execution
# 1  
Old 07-30-2007
File permission setup including execution
Oracle uses 'dbadmin' user on UNIX and one of the oracle trigger creates a file. However, it doesn't provide 'Read' & 'Write' access to 'group' & 'other' users. Per security reasons, we shouldn't use 'umask' feature. We have been trying to use 'setfacl' commands to achieve the same, but couldn't succeeded so far.

*************
cd /tmp
getfacl *TEST.TXT
setfacl -r -m u:user001:rwx *TEST.TXT
getfacl *TEST.TXT
**************

Request:
1) The created shell script (Owner: dbadmin) should be able to provide 'r', 'w' & 'x' privileges to group and other members.
2) 'User001' should be able to execute the shell script developed by dbadmin without dbadmin intevention.
Any help is greatly appreciated.

Thanks!
# 2  
Old 07-30-2007
Have DBA create the script

have DBA chmod 4777 <filename>

Anyone can execute the script (I think I did this once).

If you don't want everyone to do it, consider better security provided by sudo. While I have executed sudo <scriptname>, I have never set one up.
# 3  
Old 07-31-2007
When application user tries to execute the script which contains SETFACL command developed by DBA user group, it is coming up with the SETFACL privileges error message. Any idea!

Thanks!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX Desktop Questions & Answers

Restricted shell with execution permission on a file

Hi, I've created a user which shell is the restricted one (/usr/lib/rsh), but I've realized that the user cannot execute a script !!! The scope was to allow the ssh access to a user that could not access to any other directories but there that user should be able to run a script that retrieves ... (2 Replies)
Discussion started by: mary0
2 Replies

2. Shell Programming and Scripting

Pick the column value including comma from csv file using awk

Source 1 column1 column2 column 3 column4 1,ganesh,1,000,1 222,ram,2,000,5 222,ram,50,000,5 33,raju,5,000,7 33,raju,5,000,7 33,raju,5,000,8 33,raju,5,000,4 33,raju,5,000,1 In my .csv file, third column is having price value with comma (20,300), it has to be considered 1,000 as... (1 Reply)
Discussion started by: Ganesh L
1 Replies

3. Shell Programming and Scripting

Find file and zip without including directory path

Does anyone know of a way to zip the resulting file from a find command? My approach below finds the file and zips the entire directory path, which is not what I need. After scanning the web, it seems to be much easier to perform gzip, but unfortunately the approach must use zip. find `$DIR`... (5 Replies)
Discussion started by: koeji
5 Replies

4. Shell Programming and Scripting

Need help redirecting output to a file including errors

Need help redirecting output to a file including errors if any,I have 2 script namely push.ksh and run.ksh, I'm scp'ing push.ksh to another server and executing remotely via run.ksh, the script run.ksh runs locally but does not capture any errors in "servername.out" file (I tried testing various... (10 Replies)
Discussion started by: mbak
10 Replies

5. AIX

Execution permission denied

Hello everybody ! I'm trying to launch an application on a AIX server but I always have the error message : ksh: ./TalendOpenStudio-linux-gtk-ppc: 0403-006 Execute permission denied. while I have execution permission. I put on attached item what I have done. I have X11R6 as... (3 Replies)
Discussion started by: Bouga74
3 Replies

6. Shell Programming and Scripting

Command to get File Timestamp including seconds [Aix 5.3]

Is there a command (like ls -l) to get the file time stamp including seconds? The ls -l gives only the HH:MM, No SS I don't have a C compiler to call stat() I don't a command like stat too. Please help. (8 Replies)
Discussion started by: firdousamir
8 Replies

7. UNIX for Dummies Questions & Answers

printer setup/permission denied

Setting up a USB laserjet samsung ml1710 on a dell desktop under FC5. I used the sstem-config-software graphical interface. At the end, the test page printed fine. All seemed to go as per instructions in reference text. However if I try to print a file (as root or as user) I get a bash permission... (1 Reply)
Discussion started by: blann
1 Replies

8. Shell Programming and Scripting

including a library file ?????

Whats the syntax for including a library file in a shell script? say my shell script name is <abc.sh> and my library file is present in /user/abc/hello/fsfs/fsfsss/library.lib Please tell how to include this library file in the shell script????? (6 Replies)
Discussion started by: skyineyes
6 Replies

9. UNIX for Advanced & Expert Users

file creation date including seconds

Hi, Is anybody can help me to get the file creation date with seconds? -rw-r--r-- 1 opsc system 422550845 Aug 22 15:41 StatData.20020821 Thanks in advance Krishna (7 Replies)
Discussion started by: krishna
7 Replies

10. UNIX for Advanced & Expert Users

SAM-Execution permission denied

Hi All, I have a problem at my HP box, at command line when i type sam to access sam, the message execution permission denied comes out, What do i do? Please help Thanks (2 Replies)
Discussion started by: joylili
2 Replies
Login or Register to Ask a Question