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)



Display level


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.