\dn+
create schema schema1 authorization user1;
CREATE SCHEMA schema1;
GO
use [test]
GO
DENY SELECT ON SCHEMA::[schema1] TO [ichiro]
GO
\dn+
create schema schema1 authorization user1;
CREATE SCHEMA schema1;
GO
use [test]
GO
DENY SELECT ON SCHEMA::[schema1] TO [ichiro]
GO