Members of the db_denydatareader fixed database role cannot read any data in the user tables within a database.

 See Also

Reference

Database-Level Roles

Concepts

Permissions of Fixed Database Roles

Other Resources

sp_dbfixedrolepermission (Transact-SQL)
sp_helpdbfixedrole (Transact-SQL)
Security Considerations for Databases and Database Applications

Help and Information

Getting SQL Server 2005 Assistance