Post reply

tables access and display

  • May 25, 2011 at 9:27 pm

    #240351

    Anybody know how to display only user has permission on particular tables in the SQL server manager.

  • May 26, 2011 at 1:19 am

    #1330086

    try this..

    sp_msforeachtable 'sp_helprotect null,null,null,''?'''

    Sachin

  • May 26, 2011 at 7:32 am

    #1330307

    Actually, I person doesn't have permissions on table I don't want to display that table in the SQL server manager tray/ left side panel, thats what I want to achieve.

    Please advise me.

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

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