Audit Queries in SQL Server 2016

How do you get out of your own psychology to write characters?

Why is "rm -r" unable to delete this folder?

How to extract specific values/fields from the text file?

How to fly a direct entry holding pattern when approaching from an awkward angle?

Crack the bank account's password!

Do we still track damage on indestructible creatures?

Website seeing facebook data from another site?

Can me and my friend spend the summer in Canada (6 weeks) at 16 years old without an adult?

How do I avoid the "chosen hero" feeling?

Allow console draw poker game to output more hands

What is a good reason for every spaceship to carry gun on board?

Boss asked me to sign a resignation paper without a date on it along with my new contract

What species should be used for storage of human minds?

If I tried and failed to start my own business, how do I apply for a job without job experience?

Critique vs nitpicking

How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?

Coworker asking me to not bring cakes due to self control issue. What should I do?

Should a new user just default to LinearModelFit (vs Fit)

Is the fingering of thirds flexible or do I have to follow the rules?

How bad is a Computer Science course that doesn't teach Design Patterns?

Why is it that Bernie Sanders is always called a "socialist"?

Case protection with emphasis in biblatex

How can I prevent an oracle who can see into the past from knowing everything that has happened?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?



Audit Queries in SQL Server 2016














0















I have a database used by developers. they use a single shared account to connect and query the database.



I want to know if it exites a method to audit this database: when a request (select for example) has been executed, what is its sible (table), and by which user (@IP) ??



Thank You









share







New contributor




K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I have a database used by developers. they use a single shared account to connect and query the database.



    I want to know if it exites a method to audit this database: when a request (select for example) has been executed, what is its sible (table), and by which user (@IP) ??



    Thank You









    share







    New contributor




    K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I have a database used by developers. they use a single shared account to connect and query the database.



      I want to know if it exites a method to audit this database: when a request (select for example) has been executed, what is its sible (table), and by which user (@IP) ??



      Thank You









      share







      New contributor




      K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I have a database used by developers. they use a single shared account to connect and query the database.



      I want to know if it exites a method to audit this database: when a request (select for example) has been executed, what is its sible (table), and by which user (@IP) ??



      Thank You







      sql-server audit





      share







      New contributor




      K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 1 min ago









      K. ON BUGK. ON BUG

      1




      1




      New contributor




      K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      K. ON BUG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          K. ON BUG is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230659%2faudit-queries-in-sql-server-2016%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          K. ON BUG is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          K. ON BUG is a new contributor. Be nice, and check out our Code of Conduct.













          K. ON BUG is a new contributor. Be nice, and check out our Code of Conduct.












          K. ON BUG is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230659%2faudit-queries-in-sql-server-2016%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Szabolcs (Ungheria) Altri progetti | Menu di navigazione48°10′14.56″N 21°29′33.14″E /...

          Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

          How to make inet_server_addr() return localhost in spite of ::1/128RETURN NEXT in Postgres FunctionConnect to...