select on syscomments.text column

Summary information

Default value

1

Range of values

0–1

Status

Dynamic

Display level

Comprehensive

Required role

System Security Officer

This parameter 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 of 1 allows select permission to “public.” Set the option to 0 to restrict select permission to the object owner and the System Administrator.

To run Adaptive Server in the evaluated configuration, you must protect the source text of database objects by setting this option to 0.

See evaluated configuration in the Adaptive Server Glossary for more information.