Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSUSER system view Next Page

SYSUSERAUTHORITY system view


Each row of SYSUSERAUTHORITY system view describes an authority granted to one user ID. The underlying system table for this view is ISYSUSERAUTHORITY.

Columns
Column name Column type Column constraint
user_id UNSIGNED INT NOT NULL
auth VARCHAR(20) NOT NULL

user_id    The ID of the user to whom the authority belongs.

auth    The authority granted to the user.

Constraints on underlying system table

PRIMARY KEY (user_id, auth)

FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)