Sybase 12.4.2 manual 375, Views Default Contents

CHAPTER 10 Managing User IDs and Permissions

Table	Default	Contents
SYSUSERPERM	DBA only	Database-level permissions and
		password for each user ID
SYSGROUP	PUBLIC	One row for each member of each
		group
SYSTABLEPERM	PUBLIC	All permissions on table given by
		the GRANT commands
SYSCOLPERM	PUBLIC	All columns with UPDATE
		permission given by the GRANT
		command
SYSDUMMY	PUBLIC	Dummy table, can be used to find
		the current user ID
SYSPROCPERM	PUBLIC	Each row holds one user granted
		permission to use one procedure

The following table summarizes the system views containing information about user IDs, groups, and permissions.

Views	Default	Contents
SYSUSERAUTH	DBA only	All information in
		SYSUSERPERM except for user
		numbers
SYSUSERPERMS	PUBLIC	All information in
		SYSUSERPERM except for
		passwords
SYSUSERLIST	PUBLIC	All information in
		SYSUSERAUTH except for
		passwords
SYSGROUPS	PUBLIC	Information from SYSGROUP in a
		more readable format
SYSTABAUTH	PUBLIC	Information from
		SYSTABLEPERM in a more
		readable format
SYSCOLAUTH	PUBLIC	Information from SYSCOLPERM
		in a more readable format
SYSPROCAUTH	PUBLIC	Information from
		SYSPROCPERM in a more
		readable format

In addition to these, there are tables and views containing information about each object in the database.

375