Is there any one who can give me SQL script which allow Database Administrator to view all Users activities
@chiengdor , Welcome. Few things for you to note - please take 10mins to read the forum guidelines/rules FAQ.
There you will see that we don't write solutions per se without requestor's participation - of which you have shown/supplied none.
Secondly , which DB are you using ?
are you a regular user of the db or are you a db administrator ?
Assuming you are a db admin, and (guessing - from a similarly named user on another forum site) its ORACLE , then I recommend you start by reading material found DB AUDITING
Come back with confirmation wrt DB, your role / experience etc. and we can take it from there.
tks
Do you have any specific SQL implementation in mind ? SQL itself is reasonably standardised, but the DDL and administration activities much less so. Contrast Oracle, DB2 and MySql, for example.
"All users activities" needs careful consideration as regards level of detail. Would you want to audit every login/logout ? Interactive sessions, or those embedded in code too? All accessed tables, all commands that made any updates, every updated column in every table?
Of course, depending on that level of detail, you then need to design your tools to query the results of your audit. That is probably best done using .... a database.