Permissions for use of the system tables can be controlled by the database owner, just like permissions on any other tables. By default, when Adaptive Server is installed, the installmodel script grants select access to “public” (all users) for most system tables and for most fields in the tables. However, no access is given for some system tables, such as systhresholds, and no access is given for certain fields in other system tables. For example, all users, by default, can select all columns of sysobjects except audflags. To determine the current permissions for a particular system table, execute:
sp_helprotect system_table_name
For example, to check the permissions of systhresholds in my_database, execute:
use my_database go sp_helprotect systhresholds go
