Post reply

SQL 2005

  • November 26, 2008 at 9:48 am

    #203500

    I am looking at one SQL 2005 DB and trying to understand the security implemented.

    I can see a role having permission to execute certain stored procedure. The role includes one user.

    I cannot see any permission details at table levels like "Select, insert2 permission (like SQL 2000).

    Is the table level permission not required in SQL 2005. Say for ex. in above mentioned case the stored procedure is referring to table (may be select,insert into some table)

    Where can I see the table level permission

  • November 26, 2008 at 9:56 am

    #903900

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx

    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 2 posts - 1 through 1 (of 1 total)

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