Disabling SP_Helptext

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » Disabling SP_Helptext

Disabling SP_Helptext

Rate Topic

Display Mode

Topic Options

Author

Message

Jim-1133982

Posted Sunday, July 26, 2009 6:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 01, 2009 5:55 AM
Points: 3, Visits: 2

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

Post #759763

Lowell

Posted Sunday, July 26, 2009 8:00 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 11,605, Visits: 27,649

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #759768

sqlreader

Posted Wednesday, February 03, 2010 7:48 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:15 AM
Points: 30, Visits: 160

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

Post #858683

« Prev Topic | Next Topic »

Permissions