How would you determine who has added a row to a table?

Question Posted / guest

4 Answers
11383 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you determine who has added a row to a table?..

Answer / guest

we have to audit that particular table

Is This Answer Correct ?

4 Yes

0 No

How would you determine who has added a row to a table?..

Answer / askvenki

plz explain clearly

Is This Answer Correct ?

1 Yes

0 No

How would you determine who has added a row to a table?..

Answer / abul kasam topon

setting up FGA(fine_grain_audit) properly and we can lookup
details who & when or what updated !

Is This Answer Correct ?

1 Yes

0 No

How would you determine who has added a row to a table?..

Answer / kunal sain

use trigger.

Is This Answer Correct ?

3 Yes

4 No

Post New Answer

More DB Administration Interview Questions

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

Can you redefine a table online?

0 Answers Oracle,

how can you enable flashback feature?

0 Answers Oracle,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

How to determine the service pack currently installed on SQL Server?

1 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

How do you switch from an init.ora file to a spfile?