July 26, 2009 at 6:57 am
Hi,
I have a requirement, i want to diable "Sp_helptext" because i don't want user of the database to read the scripts that is written in the Database.
Any suggestions will be highly helpful.
Thanks
Jim
July 26, 2009 at 8:00 am
duplicate post.
no need to post the same question in multiple forums, the "Recent Posts>>Posts Added Today" makes sure your question will be seen.
follow the thread and answers posted so far here:
http://www.sqlservercentral.com/Forums/Topic759764-149-1.aspx
Lowell
February 3, 2010 at 7:48 am
If they don't have view defination they can't see anything. Only give them execute and select on procedures, functions and views.
September 24, 2017 at 11:35 pm
just use with encryption option which works well with Stored Procedures, Triggers, Functions and Views definitions.
one example :
CREATE PROCEDURE usp_mysp
WITH ENCRYPTION
as
BEGIN
// sp code
END;
try to run the command :
sp_helptext usp_mysp
it will give message that text is encrypted.
hope that helps
matin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy