sql server - How to set DENY permissions on a data user -

for .net application can store database connectionstrings

<connectionstrings config="cnn.config" /> 

i trying little permissions possible there seems different way. info.

i using settings because more secure 1 , 2 have other people working on application.

so i've set

use database_name; grant execute [security_account]; 

so user can execute commands that's fine.

then i've got db_reader , db_writer can read , write , seems perfect marriage.

still bad news user can login , see tables , store procedures definitions not alter them, however, can still see them.

how can set permissions user can read, write. execute, , period!?

being able see definition of tables, stored procedures, etc governed view definition permission. can do:

deny view definition [youruser]; 

and user won't able see definition object in database. includes ability see other users.