Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    40

    Unanswered: SQL Server permissions....

    What is the lowest level of permissions to see user created stored procedures? Example, it is possible to see "sp_" stored procedures but not yet possible to see "usp_" stored procedures.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    In SQL Server 2005, they have introduced the View Definition permission, which restricts folks from using sp_helptext on a procedure. SQL 2000 has no similar permission

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    In 2000 you can use WITH ENCRYPTION option at the time of stored procedure creation. This will encrypt the procedure code and will not show it using sp_helptext system stored procedure.

    But before encrypting the procedure, store it somewhere else for future requirement.
    Rajesh Patel

    Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •