sp_hidetext

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

Syntax

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

Parameters

objname – specifies the compiled object for which to hide the source text.
tabname – specifies the name of the table or view for which to hide the source text.
username – specifies the name of the user who owns the compiled object for which to hide the source text.

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

There are additional considerations when using sp_hidetext:

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.
sp_helprotect ... expand_predicate prints a null predicate if text has been hidden.
Hidden syscomments.text is not available for use by sp_helprotect.
The SAP ASE 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

The permission checks for sp_hidetext differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with`manage database` privilege. Any user can execute sp_hidetext to hide the source text of their own compiled objects.
Disabled	With granular permissions disabled, you must be the datatype owner or a user with sa_role. Any user can execute sp_hidetext to hide the source text of their own compiled objects.

Auditing

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

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect