Home Forums SQL Server 2005 SQL Server 2005 Security Read only and access to specific databases objects RE: Read only and access to specific databases objects

  • June 11, 2009 at 9:20 am

    #1008076

    For a user, SSMS will only list those objects where there is some privilege on that object.

    Recommend is to create a database role, grant/deny privileges to the database role and then assign database users to the database role.

    SQL = Scarcely Qualifies as a Language