مرحبا انا مبتدئ واريد ان اعرف عدد الrecords المدخلة من قبل كل مستخدم .

 

every user has his own use_name and password .

 

اتمنى ان تشرح طلبك بصورة اوضح ................... I hope you explain your request more 

اتمنى ان تشرح طلبك بصورة اوضح ................... I hope you explain your request more 

 

 

i have a tables filled with records .

many users are inserting data , but the problem is taht i dont have any history table in my database tp record each transaction done on the tables.

so if there any possibility or a solution can be used by the DBA to extract the transaction of each user .

i have a tables filled with records .

many users are inserting data , but the problem is taht i dont have any history table in my database tp record each transaction done on the tables.

so if there any possibility or a solution can be used by the DBA to extract the transaction of each user

 

 ??? .you mean you want to save the transaction to each user within specific table

if so,  i do not know, i think that not possible, but if you want to just extract this transaction for each user, this is very easy work , just use (select statement) .

 

 

example :- select transactions from tables where user='osama';

or

example :- select transactions from tables where ID='123'; 

or 

 

تم تعديل 11 سبتمبر 201411 سنة بواسطة اسامة الخالدي

افضل حل لو تقدر تعدل في البرنامج وتخليه يسجل اليوزر مع كل commit هيبقا احسن لو معندكش 

ممكن تعمل audit  علي مستوي الجدول للانسرت وهوا هيقولك اسم المستخدم

 

لتشغيل ال audit

 alter system set audit_sys_operations=TRUE scope=SPFILE;

 alter system set audit_trail=db_extended scope=SPFILE;
SHU IMMEDIATE;

STARTUP

AUDIT INSERT, UPDATE, DELETE ON mytable BY ACCESS;

تم تعديل 12 سبتمبر 201411 سنة بواسطة HELL-BOY