Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

SQL admin tool

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications SQL admin tool
# 1  
Old 06-15-2011
SQL admin tool
Hi experts,

I'm looking for a specific DB admin tool.
I'm not looking for complicated BPM(business process management) software,
what I need is just some additional functionality embedded within DB admin tool.

What I need is the
1.Approvement system - whenever there is a request/need for new record, it needs approval from separate user before record gets updated
2.Audit - logging changes made by separate users

Commercial solution is also acceptable.

Thank you
# 2  
Old 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 03:34 PM..
# 3  
Old 06-16-2011
Hi thanks

In case I don't want to write that stuff, there is not really such a software on the market?
# 4  
Old 06-16-2011
Might also be on the market as an application or API. Some friends and I were speculating on creating a generic database, where best practices are done by us as a service and the user just does their thing. I thought it might be insert-only under the covers, with log following replication.
# 5  
Old 07-18-2011
Any ideas someone?
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

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

2. What is on Your Mind?

Regarding Admin life either as DBA or UNIX Linux admin

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

3. What is on Your Mind?

Windows Admin switching to *nix Admin

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

4. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

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. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

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

6. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

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

7. UNIX for Dummies Questions & Answers

linux command line admin tool

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
Login or Register to Ask a Question