sp_hidetext

Description

Hides the source text for the specified compiled object, as well as the text of computed columns and function-based index keys. sp_hidetext also encrypts the text for user-defined functions.

Syntax

sp_hidetext [objname[, tabname[, username]]]

Parameters

Examples

Example 1

Hides the source text of all compiled objects in the current database:

sp_hidetext

Example 2

Hides the source text of the user-defined stored procedure, sp_sort_table, that is owned by Mary:

sp_hidetext @objname = "sp_sort_table", 
    @username = "Mary"

Example 3

Hides the source text of the stored procedure pr_phone_list:

sp_hidetext "pr_phone_list"

Example 4

Hides the source text of all check constraints, defaults, and triggers defined on the table my_tab:

sp_hidetext @tabname = "my_tab"

Example 5

Hides the source text of the view my_vu and all check constraints, defaults, and triggers defined on the table my_tab:

sp_hidetext "my_vu", "my_tab"

Example 6

Hides the source text of all compiled objects that are owned by Tom:

sp_hidetext @username = "Tom"

Usage

• sp_hidetext hides the source text for the specified compiled object.

  WARNING! Before executing sp_hidetext, make sure you have a backup of the source text. The results of executing sp_hidetext are not reversible.

• If you do not provide any parameters, sp_hidetext hides the source text for all compiled objects in the current database.

• Adaptive Server allows the predicate owner or the SSO to hide the text of a predicate. Hidden syscomments.text is not available for use by sp_helprotect. Users must be warned that the expand_predicate option of sp_helprotect prints a null predicate if text has been hidden.

• If you use sp_hidetext followed by a cross-platform dump and load, you must manually drop and re-create all hidden objects.

Permissions

Any user can use sp_hidetext to hide the source text of his or her own compiled objects. Only a database owner or a system administrator can hide the source text of compiled objects that are owned by another user or use sp_hidetext with no parameters.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

See also