Disabling SP_Helptext

  • Jim-1133982

    Valued Member

    Points: 67

    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: 323331

    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

    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

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply