Each row of SYSUSERAUTHORITY system view describes an authority granted to one user ID. The underlying system table for this view is ISYSUSERAUTHORITY.
| Column name | Column type | Description |
|---|---|---|
| user_id | UNSIGNED INT | The ID of the user to whom the authority belongs. |
| auth | VARCHAR(20) | The authority granted to the user. |
PRIMARY KEY (user_id, auth)
FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |