06-15-2011
Usually, you write that stuff, usually specific to the RDBMS.
- With triggers and signalling, you can divert or mark and hide from a view unapproved rows, send notification, queue for approval, move/unmark on approval. Hide from view ensures that it already conforms to constraints, but divert to queue table is more secure.
- With triggers and individual logins, you can log all table changes against the user. If you design the app as mainly insert-only, you have 100% history and other advantages.
Last edited by DGPickett; 06-15-2011 at 02:34 PM..
7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear All,
I am new to linux administration. what is the tool that is used to admin the linux server from remote client using telnet session.
It can be used on the server also but start from command line with out Xwindows.
just like SMIT in AIX.
With Regards,
Varma. (1 Reply)
Discussion started by: jarkvarma
1 Replies
2. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
3. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
4. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
5. What is on Your Mind?
I'm currently a Windows admin and have wanted to jump ship to the *nix side for a while now. I've been studying both through an lpic level 1 manual as I have time (focusing on debian), and a solaris 10 cert book. The problem is I only have a handful of hours a week to study, and my current job... (3 Replies)
Discussion started by: bobwilson
3 Replies
6. What is on Your Mind?
I am planning to choose my career as Unix/Linux Admin or a DBA. But I have come to know from forums and few admins like the job will be 24/7. I have few questions on that.
Can we get "DAY" shifts in any one of the admin Job ?
Can't we have shift timings in any company ?
Eventhough the... (7 Replies)
Discussion started by: Jacktts
7 Replies
7. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT CENTOS
ip-monitor
IP-MONITOR(8) Linux IP-MONITOR(8)
NAME
ip-monitor, rtmon - state monitoring
SYNOPSIS
ip [ ip-OPTIONS ] monitor [ all | OBJECT-LIST ] [ file FILENAME ]
DESCRIPTION
The ip utility can monitor the state of devices, addresses and routes continuously. This option has a slightly different format. Namely,
the monitor command is the first in the command line and then the object list follows:
ip monitor [ all | OBJECT-LIST ] [ file FILENAME ]
OBJECT-LIST is the list of object types that we want to monitor. It may contain link, address, route, mroute, prefix, neigh and netconf.
If no file argument is given, ip opens RTNETLINK, listens on it and dumps state changes in the format described in previous sections.
If the file option is given, the program does not listen on RTNETLINK, but opens the given file, and dumps its contents. The file should
contain RTNETLINK messages saved in binary format. Such a file can be generated with the rtmon utility. This utility has a command line
syntax similar to ip monitor. Ideally, rtmon should be started before the first network configuration command is issued. F.e. if you
insert:
rtmon file /var/log/rtmon.log
in a startup script, you will be able to view the full history later.
Nevertheless, it is possible to start rtmon at any time. It prepends the history with the state snapshot dumped at the moment of starting.
SEE ALSO
ip(8)
AUTHOR
Original Manpage by Michail Litvak <mci@owl.openwall.com>
iproute2 13 Dec 2012 IP-MONITOR(8)