datareader can see code

the new user has only datareader but is able to read the procs, udf  etc

datareader means they can read any code on the db? (along with selects on any tables/views)
LVL 5
25112Asked:
Who is Participating?
 
x-menIT super heroCommented:
you can give permissions to especific tables and views
0
 
x-menIT super heroCommented:
...and remove
0
 
x-menIT super heroCommented:
...or deny
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
LowfatspreadCommented:
i didn't think datareader included definition ... by default but i'd have to check...

deny defintion if you don't want them to be able to see code etc

or you certain they aren't inheriting some other roles etc..? (e.g. admin)
0
 
25112Author Commented:
deny worked good.
0
 
LowfatspreadCommented:
unlrss the code is encrypted , they can probablu still see the definition of the stored procedures by looking at the dara in either the information_achema tables or the sysrem tables ... if you have still left them with datareader.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.