Post reply

How do I grant 'view definition' on a proc in SQL Server 2000?

  • October 13, 2008 at 5:34 pm

    #96554

    When I run this...

    grant view definition on [dbo].[xxxx_Billpay] to xxxxx

    go

    I get the following...

    Msg 156, Level 15, State 1, Line 1

    Incorrect syntax near the keyword 'view'.

    How do I grant a developer access to view the definition of a proc without giving him additional rights?

    Thanks!!!

  • October 14, 2008 at 1:50 am

    #884448

    View definition is not a permission level in SQL 2000. It was introduced in 2005 along with the tightening of the metadata security.

    In 2000, iirc, everyone could view the definition of objects even if they had no other rights at all. That changed in 2005.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 14, 2008 at 10:15 am

    #884739

    Thanks for the help!

  • October 14, 2008 at 10:32 am

    #884752

    If your dev's getting an error, post the full error message here and we can help diagnose the cause.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 4 (of 4 total)

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