Amir, The syntax "ug+s" can be interpreted as following:
u (file owner) and g (group) "+" - to add permission "s", which means: Set-user-ID-on-execution permission if the u flag is specified or implied. Set-group-ID-on-execution permission if the g flag is specified or implied. Cheers, Ellen Reys Data Management Services Inovant - a Visa Solutions Company [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D -----Original Message----- From: Amir Sadeghi [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 4:29 PM To: [EMAIL PROTECTED] Subject: Re: [DB2EUG] Allowing a tester to backup/restore Steve, The first option sounds like exactly what I'd like to do. However, reading the man pages on chmod, I'm confused on the syntax. The manpages says that the syntax is: chmod ug+s cmd (where cmd is the executable) What I don't get is where I specify the userid that can run this executable. Do you know of an example? Thanks for your help and I really appreciate your input. >From: [EMAIL PROTECTED] >To: "Amir Sadeghi" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED], [EMAIL PROTECTED] >Subject: Re: [DB2EUG] Allowing a tester to backup/restore >Date: Mon, 1 Apr 2002 14:29:43 -0600 > > >Amir, > >Here are a couple of other approaches you might consider that do not >involve giving DBA authority to end users. > >One approach would be to set up something using the UNIX "set user ID" bit. >Using this, you could create a program or shell script that would perform >the backup or restore. The set user ID feature lets the program execute >under the User ID of the person owning the program, not the one executing >it. (See the man page for "chmod.") > >Another approach would be to set up some kind of queuing mechanism that >would allow users to submit the names of tables that they want backed up or >restored. This might be as simple as having a file that users could edit, >where they could add the schema and name of the table and the action to be >taken (i.e., backup or restore). Or you could have a DB2 table where they >could insert a row having that same information. Then you could write a >program or shell script that would read the file or table, take the >appropriate action, then clear out the queue. > >Steve Westfall >Equifax, Inc. > Amir _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
