select on syscomments.text

select on syscomments.text enables protection of the text of database objects through restriction of the select permission on the text column of the syscomments table.

Summary Information

Default value

0 (off)

Range of values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System security officer

Configuration group

Security Related

The default value sets select permission to “public.” Set the value to 0 to restrict select permission to the object owner and the system administrator.