Hi,

How can I set with a file with the following attribute.
" -rwsr-sr-s "

-rwsr-s--x 1 oracle dba 106M Aug 25 2002 oracle.

Thanks in advance.

It is not possible: it can be set for user and group only. These are the SUID and SGID respectively: they allow users to run an executable with the permissions of the file owner or group. Setting the permission for the world (other) does not make sense.

colucix,

Yes , I want to execute sqlplus as user username(valid user) with the DBA credentials. It shows me the following error.
$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 27 14:15:21 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: username
Enter password:
ERROR:
ORA-01034: Message 1034 not found; No message file for product=RDBMS,
facility=ORA
ORA-27121: Message 27121 not found; No message file for product=RDBMS,
facility=ORA
Linux-x86_64 Error: 13: Permission denied


So, we need to set the permission as above, as we have other servers already up and running with the same " -rwsr-sr-s " permissions.
Can I get the option for chmod to do that.


Thank you

did you try chmod u=rws,g=rs,o=rs <file>

Nathanael,

I got "-rwSr-Sr-s " , when I try with chmod u=rws,g=rs,o=rs <file>.

SORRY A CORRECTION : I want to set permission as "-rwsr-s--x "

Thanks

The uppercase S means that the SUID and/or SGID are set but the executable permission is not. You have to do
Then, if you want permission -rwsr-s--x you have to do
or use the octal codes to set all the permissions you want in one shot

Thank you colucix