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.