Home » SQL & PL/SQL » SQL & PL/SQL » SQL Query verification (Oracle 10)
SQL Query verification [message #360087] Wed, 19 November 2008 09:23 Go to next message
aotto1968
Messages: 1
Registered: November 2008
Location: Germany
Junior Member
Hi,

I have a requirement for a tool to verify a SQL statement
submitted to a production environment before the statement
is executed.

to verify mean to disallow special sql commands like DROP or TRUNCATE or just allow special sql commands like UPDATE or INSERT

the goal is to create a web interface for upgrading the sql
data or the database-layout for users with no write permission.

mfg

Andreas Otto
Re: SQL Query verification [message #360101 is a reply to message #360087] Wed, 19 November 2008 10:49 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
What is your question?

Are you asking for advice on how to create such a thing?

Check out DBMS_SQL. You can write your own procedure to parse a query to figure out the simple things you have said. Indeed, I think the documentation has a working example that does 95% of the work you want; assuming this is what you want.

Good luck, Kevin
Re: SQL Query verification [message #360106 is a reply to message #360087] Wed, 19 November 2008 11:31 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't want some users to do some things just don't grant them the privilege to do it.

Regards
Michel
Previous Topic: ORA-01406: fetched column value was truncated
Next Topic: [merged] better way of doing this / not going inside FOR loop
Goto Forum:
  


Current Time: Tue Dec 06 10:08:14 CST 2016

Total time taken to generate the page: 0.12541 seconds