عدد الrecords المدخلة من قبل كل مستخدم .

[mtt79]

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

 

every user has his own use_name and password .

 

[اسامة الخالدي]

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

[mtt79]

اتمنى ان تشرح طلبك بصورة اوضح ................... 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 .

[mtt79]

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 سبتمبر 2014 بواسطة اسامة الخالدي

[HELL-BOY]

افضل حل لو تقدر تعدل في البرنامج وتخليه يسجل اليوزر مع كل 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 سبتمبر 2014 بواسطة HELL-BOY