Home Forums SQL Server 2012 SQL 2012 - General Stop users from expanding the Tables nodes in Object Explorer RE: Stop users from expanding the Tables nodes in Object Explorer

  • I don't think you can disable the expanding option, but users can only see those tables, which they have select permission on.

    So unless you give select permission to either public or the user, they won't see any tables.

    [font="Verdana"]Markus Bohse[/font]