25112
asked on
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)
datareader means they can read any code on the db? (along with selects on any tables/views)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
x-men
...and remove
...or deny
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
deny worked good.
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.