Revoking Default Permissions on System Tables

Revokes default permissions on all system tables from “public.”

The system tables you can revoke the default permissions for when you issue the command from any database are:

  • sysalternates

  • sysattributes

  • syscolumns

  • syscomments

  • sysconstraints

  • sysdepends

  • sysindexes

  • sysjars

  • syskeys

  • syslogs

  • sysobjects

  • syspartitions

  • sysprocedures

  • sysprotects

  • sysqueryplans

  • sysreferences

  • sysroles

  • syssegments

  • sysstatistics

  • systabstats

  • systhresholds

  • systypes

  • sysusermessages

  • sysusers

  • sysxtypes

The system tables you revoke the default permissions for when you issue this command from the master database are:

  • sysdatabases

  • sysdevices

  • syslocks

  • sysmessages

  • sysprocesses

  • systransactions

  • sysusages

  • sysconfigures

  • syscurconfigs

  • syslanguages

  • syscharsets

  • sysservers

  • systimeranges

  • sysresourcelimits

  • syslogins

  • sysremotelogins