Sybase Adaptive Server Anywhere - SYSTABLEPERM System Table

Chapter 15 System Tables
1041
SYSTABLEPERM system table
Column name Column type
Column
constraint
Table
constraints
stable_id UNSIGNED INT NOT NULL Primary key,
foreign key
references
SYSTABLE
table_id
grantee UNSIGNED INT NOT NULL Primary key,
foreign key
references
SYSUSERPERM
.user_id
grantor UNSIGNED INT NOT NULL Primary key,
foreign key
references
SYSUSERPERM
.user_id
ttable_id UNSIGNED INT NOT NULL Foreign key
references
SYSTABLE
table_id
selectauth CHAR(1) NOT NULL
insertauth CHAR(1) NOT NULL
deleteauth CHAR(1) NOT NULL
updateauth CHAR(1) NOT NULL
updatecols CHAR(1) NOT NULL
alterauth CHAR(1) NOT NULL
referenceauth CHAR(1) NOT NULL
Permissions given by the GRANT command are stored in
SYSTABLEPERM. Each row in this table corresponds to one table, one
user ID granting the permission (grantor) and one user ID granted the
permission (grantee).
There are several types of permission that can be granted. Each permission
can have one of the following three values.
♦
N No, the grantee has not been granted this permission by the grantor.
♦
Y Yes, the grantee has been given this permission by the grantor.