SQL 2005 - Sysprocesses Permission

SQL 2000 default permissions allowed user (without System Administrator Rights) to obtain the list of processes querying sysprocess.

SQL 2005 doesn't allow it and you must explicit grant VIEW SERVER STATE permission to users.
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

1 comments:

Marco Frattola said...

ah beh, hanno impiegato 5 anni per risolvere un bug del genere... c'è proprio da andarne fieri!