Post reply

is it possible to discern who created an object in a db like ferinstance

  • November 26, 2013 at 2:44 pm

    #282851

    the windows login or network name of the creator of a view, something along the lines of View->Properties->Current User, but instead of seeing my current connection properties, have something like ObjectAuthor or ObjectCreator returned?

    If that is not possible out of the box, will some policy or other feature (other than triggers, which I fear would be a ton of overhead) log object creation/alteration events or does that have to be trapped at the time with triggers and a home grown logging table?

    thanks very much

    drew

  • November 26, 2013 at 2:59 pm

    #1669276

    if not too much time has passed, it will be in the default trace;

    but the default trace only keeps a rolling history of 100 meg, so it could get pushed out of scope quickly on a server witha lot of DDL going on.

    going forward, you could add a DDL trigger, or a trace, or extended events to watch in the future.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 26, 2013 at 9:18 pm

    #1669319

    Perfect!

    Thanks very much, I appreciate it

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply