Disabling SP_Helptext

• Jim-1133982

  SSC Enthusiast

  Points: 167

  More actions

  July 26, 2009 at 6:57 am

  #212817

  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

• Lowell

  SSC Guru

  Points: 323518

  More actions

  July 26, 2009 at 8:00 am

  #1030275

  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

  ---

  --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!

• sqlreader

  SSC Journeyman

  Points: 92

  More actions

  February 3, 2010 at 7:48 am

  #1112896

  If they don't have view defination they can't see anything. Only give them execute and select on procedures, functions and views.

• matin_sayed-724572

  Valued Member

  Points: 63

  More actions

  September 24, 2017 at 11:35 pm

  #1960665

  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