Post reply

Permissions to see last TSQL command

  • October 7, 2003 at 7:51 am

    #59450

    Hi there,

    which permisions do I need at least to see the last TSQL command under Current Activity->Process Info?

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 7, 2003 at 7:57 am

    #477373

    You actually call dbcc inputbuffer command to see the last TSQL command.

    DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server role only, who can see any SPID. Other users can see any SPID they own. Permissions are not transferable.

  • October 7, 2003 at 8:01 am

    #477376

    Hi Allen,

    quote:

    You actually call dbcc inputbuffer command to see the last TSQL command.

    DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server role only, who can see any SPID. Other users can see any SPID they own. Permissions are not transferable.

    thanks!

    Unfortunately this is not the answer I wanted to hear as we moved my db's to a central server on which I am no longer sysadmin

    I guess there are no workarounds?

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 7, 2003 at 8:07 am

    #477379

    Unfortunately you can see only SPID and last statement with dbcc inputbuffer you own if you are not 'sysadmin'.

  • October 7, 2003 at 8:15 am

    #477385

    hm...any experience with 'processadmin'?

    that little that is in BOL sounds interesting

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 7, 2003 at 8:30 am

    #477391

    I tried, It doesn't have to permissions to see other people's processes. It can be use to kill processes.

  • October 8, 2003 at 2:22 am

    #477484

    quote:

    I tried, It doesn't have to permissions to see other people's processes. It can be use to kill processes.

    Thanks again!

    Would have been nice

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 8, 2003 at 3:13 am

    #477497

    Btw, I've been added back to sysadmins.

    It pays when you keep the network admins who control the server busy with something they can't answer

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

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