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

Question Posted / guest

4 Answers
9644 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

when does an alert gets signaled?

0 Answers Oracle,

What authentication modes does sql server support? : sql server DBA

0 Answers

wat is global index and local indes

1 Answers Oracle,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

What the different types of replication and why are they used? : sql server DBA

0 Answers

What is dbcc? : sql server DBA

0 Answers

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers

What type of index should you use on a fact table?

1 Answers

What purpose does the model database server? : sql server DBA

0 Answers

How would you determine the time zone under which a database was operating?