Post reply

Table level privileges

  • September 16, 2004 at 1:50 pm

    #59946

    Is there any query to pull out table level privileges.

    example

    If there a table called  A . John ,Hughes and Harry are users have access to it with john ,hughes having select privileges and harry having

    select,insert privileges  . .the report should look like

                   

     

                    select    update insert   delete

    A

     

    John             y                   

    Harry            y                     y

    Hughes          y

     

     

    Any help would be greatly appreciated

     

    Thanks

    Sai

     

     

     

  • September 16, 2004 at 2:31 pm

    #523418

    Look up sp_table_privileges and sp_table_privileges_ex in BOL.

  • September 16, 2004 at 3:25 pm

    #523424

    Thanks a bunch  .I may have to modify it to suit my needs .

  • September 17, 2004 at 8:59 am

    #523516

    Try:  sp_helprotect

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

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