Q: ORACLE Logon Account

We are developing an application with OCI calling ORACLE DML statements and also PL/SQL routines.

Our problem is how to connect to the database; as one account per user or one specific account (hidden in the application).

We would like to have one account per user, BUT this is not to good because each account requires the SELECT, INSERT, UPDATE and DELETE privileges which in turn means that they can enter SQL*PLus and destroy the information. (This is no problem for the PL/SQL routines which encapsulates the table processings).

Question: It seams impossible to have one account per user (to ensure the sequrity)

	  if there are business specific rules & management in an application that
	  process the information WIHTOUT using PL/SQL!? 
	  

Will GRANT EXECUTE ever work for OS applications? ;-)

+------------------------------------------------------------------+

+       _/_/_/    _/_/_/   _/_/_/_/  Roger Bjärevall               +
+      _/    _/  _/    _/       _/   BO/EBC/FL/RGFC                +
+     _/    _/  _/    _/       _/    Ericsson Business Networks AB +
+    _/_/_/_/  _/_/_/_/       _/     135 83 Tyresö                 +
+   _/  _/    _/    _/  _/   _/      Sweden                        +
+  _/    _/  _/    _/  _/   _/       +46 8 6824851                 +
+ _/     _/ _/_/_/      _/_/         email: ebcrbj_at_ebc.ericsson.se +


+------------------------------------------------------------------+