Originally Posted by faruque.ahmed

Hi,
I have create a user using the following command
useradd -d /home/rozan -s /bin/bash -c "Rozan ahmed" -g dba rozan

I would like to give her only the read only access to

$BDUMP_HOME/alert.log file

The owner of the file is oracleinstall
Regards
Faruque

Originally Posted by johnf

What is the permission settings on the filesystem (drwxrwxr--)?

Originally Posted by faruque.ahmed

-rw-r-----

Originally Posted by tayyabq8

Make it -rw-r--r-- or if you don't want to give read access to every one then make that particular user a member of the same group which oracle_install belongs.

Originally Posted by faruque.ahmed

SSH Secure Shell 3.2.9 (Build 283)
Copyright (c) 2000-2003 SSH Communications Security Corp - http://www.ssh.com/

This copy of SSH Secure Shell is a non-commercial version.
This version does not include PKI and PKCS #11 functionality.


Last login: Wed Jan 31 21:47:23 2007 from 10.13.8.87
[root@oper-db ~]# userdel rozan
[root@oper-db ~]# useradd -d /home/rozan -s /bin/bash -c "Rozan Ahmed" -g oinstall rozan
[root@oper-db ~]# su - oracle
[oracle@oper-db ~]$ cd /uo01/app/oracle/admin/operdb/bdump/
[oracle@oper-db bdump]$ chmod 644 alert_operdb.log
[oracle@oper-db bdump]$ ls -ltr
total 332
-rw-r----- 1 oracle oinstall 808 Jan 31 02:41 operdb_lgwr_7864.trc
-rw-r----- 1 oracle oinstall 616 Jan 31 02:42 operdb_arc1_7946.trc
-rw-r----- 1 oracle oinstall 616 Jan 31 02:42 operdb_arc0_7944.trc
-rw-r----- 1 oracle oinstall 1072 Jan 31 02:42 operdb_lgwr_7924.trc
-rw-r----- 1 oracle oinstall 675 Jan 31 02:47 operdb_arc0_7988.trc
-rw-r----- 1 oracle oinstall 813 Jan 31 02:47 operdb_arc2_7992.trc
-rw-r----- 1 oracle oinstall 1019 Jan 31 02:49 operdb_arc1_7990.trc
-rw-r----- 1 oracle oinstall 983 Jan 31 02:49 operdb_lgwr_7968.trc
-rw-r----- 1 oracle oinstall 815 Jan 31 02:55 operdb_arc2_11996.trc
-rw-r----- 1 oracle oinstall 1385 Jan 31 03:55 operdb_arc1_11994.trc
-rw-r----- 1 oracle oinstall 4612 Jan 31 03:58 operdb_arc0_11992.trc
-rw-r----- 1 oracle oinstall 5635 Jan 31 03:59 operdb_pmon_11964.trc
-rw-r----- 1 oracle oinstall 1077 Jan 31 03:59 operdb_lgwr_11972.trc
-rw-r----- 1 oracle oinstall 801 Jan 31 04:12 operdb_p002_18150.trc
-rw-r----- 1 oracle oinstall 799 Jan 31 04:12 operdb_p001_18148.trc
-rw-r----- 1 oracle oinstall 799 Jan 31 04:12 operdb_p000_18146.trc
-rw-r----- 1 oracle oinstall 3860 Jan 31 04:13 operdb_dbw0_18094.trc
-rw-r----- 1 oracle oinstall 815 Jan 31 04:18 operdb_arc2_18156.trc
-rw-r----- 1 oracle oinstall 955 Jan 31 22:00 operdb_lgwr_18096.trc
-rw-r--r-- 1 oracle oinstall 58428 Jan 31 22:00 alert_operdb.log
-rw-r----- 1 oracle oinstall 16310 Feb 1 02:18 operdb_arc0_18152.trc
-rw-r----- 1 oracle oinstall 76204 Feb 1 02:19 operdb_arc1_18154.trc
[oracle@oper-db bdump]$ exit
logout
[root@oper-db ~]#
[root@oper-db ~]# su - rozan
[rozan@oper-db ~]$ cd /uo01/app/oracle/admin/operdb/bdump/
[rozan@oper-db bdump]$ ls -ltr
total 332
-rw-r----- 1 oracle oinstall 808 Jan 31 02:41 operdb_lgwr_7864.trc
-rw-r----- 1 oracle oinstall 616 Jan 31 02:42 operdb_arc1_7946.trc
-rw-r----- 1 oracle oinstall 616 Jan 31 02:42 operdb_arc0_7944.trc
-rw-r----- 1 oracle oinstall 1072 Jan 31 02:42 operdb_lgwr_7924.trc
-rw-r----- 1 oracle oinstall 675 Jan 31 02:47 operdb_arc0_7988.trc
-rw-r----- 1 oracle oinstall 813 Jan 31 02:47 operdb_arc2_7992.trc
-rw-r----- 1 oracle oinstall 1019 Jan 31 02:49 operdb_arc1_7990.trc
-rw-r----- 1 oracle oinstall 983 Jan 31 02:49 operdb_lgwr_7968.trc
-rw-r----- 1 oracle oinstall 815 Jan 31 02:55 operdb_arc2_11996.trc
-rw-r----- 1 oracle oinstall 1385 Jan 31 03:55 operdb_arc1_11994.trc
-rw-r----- 1 oracle oinstall 4612 Jan 31 03:58 operdb_arc0_11992.trc
-rw-r----- 1 oracle oinstall 5635 Jan 31 03:59 operdb_pmon_11964.trc
-rw-r----- 1 oracle oinstall 1077 Jan 31 03:59 operdb_lgwr_11972.trc
-rw-r----- 1 oracle oinstall 801 Jan 31 04:12 operdb_p002_18150.trc
-rw-r----- 1 oracle oinstall 799 Jan 31 04:12 operdb_p001_18148.trc
-rw-r----- 1 oracle oinstall 799 Jan 31 04:12 operdb_p000_18146.trc
-rw-r----- 1 oracle oinstall 3860 Jan 31 04:13 operdb_dbw0_18094.trc
-rw-r----- 1 oracle oinstall 815 Jan 31 04:18 operdb_arc2_18156.trc
-rw-r----- 1 oracle oinstall 955 Jan 31 22:00 operdb_lgwr_18096.trc
-rw-r--r-- 1 oracle oinstall 58428 Jan 31 22:00 alert_operdb.log
-rw-r----- 1 oracle oinstall 16310 Feb 1 02:18 operdb_arc0_18152.trc
-rw-r----- 1 oracle oinstall 76318 Feb 1 02:21 operdb_arc1_18154.trc
[rozan@oper-db bdump]$ vi alert_operdb.log
Wed Jan 31 02:39:59 2007
[rozan@oper-db bdump]$ ls
alert_operdb.log operdb_arc1_18154.trc operdb_dbw0_18094.trc operdb_p000_18146.trc
operdb_arc0_11992.trc operdb_arc1_7946.trc operdb_lgwr_11972.trc operdb_p001_18148.trc
operdb_arc0_18152.trc operdb_arc1_7990.trc operdb_lgwr_18096.trc operdb_p002_18150.trc
operdb_arc0_7944.trc operdb_arc2_11996.trc operdb_lgwr_7864.trc operdb_pmon_11964.trc
operdb_arc0_7988.trc operdb_arc2_18156.trc operdb_lgwr_7924.trc
operdb_arc1_11994.trc operdb_arc2_7992.trc operdb_lgwr_7968.trc
[rozan@oper-db bdump]$ rm -rf operdb_lgwr_7968.trc
[rozan@oper-db bdump]$
[rozan@oper-db bdump]$ ls operdb_lgwr_7968.trc
ls: operdb_lgwr_7968.trc: No such file or directory
[rozan@oper-db bdump]$





i would not like to give her the permission to delete any files







regards