BUS7 Consulting

GRANT SELECT ON SCHEMA::dbo TO UserName;
GO

DENY SELECT ON SCHEMA::dbo TO UserName;

GO

Obsolete 'sp_helprotect' :

EXEC SP_helprotect @username = 'Username';
GO

View security settings for a Schema:

select class,SCHEMA_NAME(major_id) [Schema],USER_NAME([grantee_principal_id])[User],
permission_name,state_desc

FROM sys.[database_permissions]

WHERE SCHEMA_ID('dbo')=major_id AND class=3;