Login or Register to Ask a Question and Join Our Community


AIX

Prevent admin user accidentally remove database files.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX Prevent admin user accidentally remove database files.
# 1  
Old 03-12-2014
Prevent admin user accidentally remove database files.
Hi Folks,
Any system admin did provide AIX file system control to prevent user/ admin accidentally remove database files ?


Thanks.
# 2  
Old 03-13-2014
Remove access to the files except for the database owner account (oracle, ingres, informix etc.)

Change the root password and do not let anyone else have it or unlimited sudo access.

Change the permissions on the DB files to be RW to owner only.



Robin
Last edited by rbatte1; 03-13-2014 at 11:12 AM.. Reason: Emboldening
# 3  
Old 03-13-2014
What database files are you talking about, in AIX...
Issues with the ODM?
# 4  
Old 03-13-2014
The issue is due to client conventional setup of using db instance user and app user are similar, user afraid of app admin when login accidentally remove the database datafiles.
# 5  
Old 03-14-2014
Best to change the Application id then.

Keep the application and the database owner separate. It might be convenient, but you expose yourself to risk, as you have determined.



Security is like birth control. No-one who is having a good time wants to think about it, but then if it's too late, you can be in seriously expensive trouble.





Robin
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Prevent user from creating new user from his login

Hi Experts, Need your support Redhat 6.5 I want to create a user with all(read, write, execute) privileges except that user should not be able to create any new user from his login to perform any task. (10 Replies)
Discussion started by: as7951
10 Replies

2. Shell Programming and Scripting

Prevent the user from changing his directory

Hi could some let me know how to prevent user from changing his home directory....... Thanks in advance.... (6 Replies)
Discussion started by: rahul547
6 Replies

3. Shell Programming and Scripting

Prevent the user from changing his directory

Hi could some let me know how to prevent user from changing his home directory....... Thanks in advance.... (1 Reply)
Discussion started by: Revanth547
1 Replies

4. Shell Programming and Scripting

Write a scripts to kill idle user for 60 min. & email user list to admin in text file

Folks, I have written one script for following condition by referring some of online post in this forum. Please correct it if I'm missing something in it. (OS: AIX 5.3) List the idle user. (I used whoidle command to list first 15 user and get username, idle time, pid and login time).... (4 Replies)
Discussion started by: sumit30
4 Replies

5. IP Networking

how to prevent a user from downloading on lan

hi all, i want to prevent users downloading files in the office as bandwidth becomes very low and affects work. one of my friend tried to close the connection using ethercap but this does not work. i have a debian desktop while other users use MS W!ndows. Please provide any help. Thanks (5 Replies)
Discussion started by: coolatt
5 Replies

6. UNIX for Dummies Questions & Answers

How to remove/prevent Input/output error

Hi I have a new hdd installed ,and sometimes if i start a session or ftp download while downloading sometimes it creates a ./filename.type Input/output errorso in that case i can-not overwrite ,rename ,remove ,or place a file with the same name on that dir. How to prevent this and is there... (3 Replies)
Discussion started by: brain!ac
3 Replies

7. Cybersecurity

prevent user from excute command

Dears I want to prevent users from doing spesific command "history -c" or "history" in general How can I do ? (4 Replies)
Discussion started by: reaky
4 Replies

8. UNIX for Advanced & Expert Users

How to prevent local root from su to an NIS user?

We have a shared development box, running Solaris 10 that is an NIS client, all the developers have local root password. If they know the NIS uid of another user, they can just do % useradd -u <uid> login And then log in as that user and have full access to his files in his home directory. ... (3 Replies)
Discussion started by: nfw
3 Replies

9. UNIX for Dummies Questions & Answers

accidentally remove the contents of /var/sadm/pkg

Hi all, I carelessly remove the contents of /var/sadm/pkg. I do not have any backup of the folder. What can I do ? Thanks a lot. :eek: (11 Replies)
Discussion started by: stancwong
11 Replies

10. UNIX for Advanced & Expert Users

Accidentally deleting directory/files

Hi, I accidentally deleted a big directory with all its sub-directories and bunch of source code files which I have been developing for about 2 years... What will I do now, how can I retrieve my files, directory hierarchy back ??? If anyone, please HELP ! ! ! ... (4 Replies)
Discussion started by: milhan
4 Replies
Login or Register to Ask a Question