how do i creat a complete log of my database and its user

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zalan
    New Member
    • Sep 2006
    • 6
    #1

    how do i creat a complete log of my database and its user

    plz help me in making a complete log file for all the activities on my database and all users. like i should get all information abt every user the number of record enterd by each user and time like this
    plz help me
    Tags: None
    • PEB
      Recognized Expert Top Contributor
      • Aug 2006
      • 1418
      #2
      Hi,

      U have to use Code !!! :)

      Which RDBMS do you use?\\

      And why do not post this thread in the forums of databases?

      :)

        Comment

        • zalan
          New Member
          • Sep 2006
          • 6
          #3
          Originally posted by PEB
          Hi,

          U have to use Code !!! :)

          Which RDBMS do you use?\\

          And why do not post this thread in the forums of databases?

          :)
          im usin 9i database and 6i forms

            Comment

            • PEB
              Recognized Expert Top Contributor
              • Aug 2006
              • 1418
              #4
              If Oracle doesn't supply this as a feuatre you have to organize your tables so that you have to use only Append operations on your tables...

              Every record of the table need to be marked - with true if it is activ and with false if not...

              Also you need a field for the user and the time sand date stamp...

              And your log have to be ready...

              But in Access 2007 Microsoft supplies a functionality like log on a field, trecord, table.... It will be stange if Oracle doesn't....

              :)

                Comment

                Previous template Next
                Working...