select on syscomments.text

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

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. 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.