How to mark it down when a user select a field from a table as a log record??


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: How to mark it down when a user select a field from a table as a log record??

  1. #1
    Mabel Guest

    How to mark it down when a user select a field from a table as a log record??


    How to mark it down when a user select a field from a table as a log record??

  2. #2
    David Satz Guest

    Re: How to mark it down when a user select a field from a table as a log record??

    you can audit it by creating a stored proc as the only means of access to
    the field, but sounds like you are looking at ad-hoc queries in which case,
    you should check out SQL Profiler:
    http://msdn.microsoft.com/library/de...us/adminsql/ad
    _mon_perf_86ib.asp

    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions

    "Mabel" <misuzu129@sinagirl.com> wrote in message
    news:3e8bd48f$1@tnews.web.devx.com...
    >
    > How to mark it down when a user select a field from a table as a log

    record??



  3. #3
    Mabel Guest

    Re: How to mark it down when a user select a field from a table as a log record??


    how can I do that by using stored procedure??

    "David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote:
    >you can audit it by creating a stored proc as the only means of access to
    >the field, but sounds like you are looking at ad-hoc queries in which case,
    >you should check out SQL Profiler:
    >http://msdn.microsoft.com/library/de...us/adminsql/ad
    >_mon_perf_86ib.asp
    >
    >--
    >HTH,
    >David Satz
    >Principal Web Engineer
    >Hyperion Solutions
    >
    >"Mabel" <misuzu129@sinagirl.com> wrote in message
    >news:3e8bd48f$1@tnews.web.devx.com...
    >>
    >> How to mark it down when a user select a field from a table as a log

    >record??
    >
    >



  4. #4
    David Satz Guest

    Re: How to mark it down when a user select a field from a table as a log record??

    you would need to make sure no users have SELECT writes to the table(s)
    and/or column(s) and then provide a stored proc to access that table. It is
    more of a control access function than log access function, but you can use
    it for both, i.e. you can have 2 version of the stored proc: 1 that returns
    all columns and 1 that returns all un-logged columns. The latter could
    write a row to a table everytime it is run logging the access...

    "Mabel" <a@abc.com> wrote in message news:3e8d578a$1@tnews.web.devx.com...
    >
    > how can I do that by using stored procedure??
    >
    > "David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote:
    > >you can audit it by creating a stored proc as the only means of access to
    > >the field, but sounds like you are looking at ad-hoc queries in which

    case,
    > >you should check out SQL Profiler:

    >
    >http://msdn.microsoft.com/library/de...-us/adminsql/a

    d
    > >_mon_perf_86ib.asp
    > >
    > >--
    > >HTH,
    > >David Satz
    > >Principal Web Engineer
    > >Hyperion Solutions
    > >
    > >"Mabel" <misuzu129@sinagirl.com> wrote in message
    > >news:3e8bd48f$1@tnews.web.devx.com...
    > >>
    > >> How to mark it down when a user select a field from a table as a log

    > >record??
    > >
    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center