Syed Jahanzaib Bin hassan (7/1/2011)
if you have passed the T-sql GRANT SELECT ON
TO then he cant access the systems databases and systems objects even other user objects
while he cannot ACCESS the system objects, he's talking about seeing the names of those objects, which is inherited from the PUBLIC role.
the issue is very similar to a DOD security requirement;
see this thread for an example which generates teh statemetns to remove access to PUBLIC and GUEST for sys views :
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!