Sybase 12.4.2 manual System view Description, Sysuserauth

CHAPTER 1 Overview of Adaptive Server IQ System Administration

System view	Description
SYSCATALOG	Lists all tables and views from
	SYSTABLE
SYSCOLAUTH	Presents column update permission
	information from SYSCOLPERM
SYSCOLUMNS	Presents a readable version of the table
	SYSCOLUMN
SYSFOREIGNKEYS	Presents foreign key information from
	SYSFOREIGNKEY and SYSFKCOL
SYSGROUPS	Presents group information from
	SYSGROUP
SYSINDEXES	Presents index information from
	SYSINDEX and SYSIXCOL
SYSOPTIONS	Displays option settings contained in
	the table SYSOPTION
SYSPROCPARMS	Lists all the procedure parameters
	from SYSPROCPARM
SYSREMOTEUSERS	Lists the information in
	SYSREMOTEUSER
SYSTABAUTH	Presents table permission information
	in SYSTABLEPERM
SYSUSERAUTH	Displays all the information in the
	table SYSUSERPERM except for user
	numbers. Because it contains
	passwords, this system view does not
	have PUBLIC select permission
SYSUSERLIST	Presents all information in
	SYSUSERAUTH except for
	passwords
SYSUSEROPTIONS	Display effective permanent option
	settings for each user
SYSUSERPERMS	Contains exactly the same information
	as the table SYS.SYSUSERPERM
	except the password is omitted
SYSVIEWS	Lists views and their definitions

For a complete description of system tables and views and their contents, see

the Adaptive Server IQ Reference Manual.

15