sysusermessages  sysxtypes

Chapter 1: System Tables

sysusers

All databases

Description

sysusers contains one row for each user allowed in the database, and one row for each group or role.

Columns

The columns for sysusers are:

Name

Datatype

Description

suid

int

Server user ID, copied from syslogins.

uid

int

User ID, unique in this database, is used for granting and revoking permissions. User ID 1 is “dbo”.

gid

int

Group ID to which this user belongs. If uid = gid, this entry defines a group. Negative values may be used for user IDs (uid). Every suid associated with a group or a role in sysusers is set to -2 (INVALID_SUID).

name

sysname

User or group name, unique in this database.

environ

varchar(255) null

Reserved.

On the Adaptive Server distribution media, master..sysusers contains some initial users: “dbo”, whose suid is 1 and whose uid is 1; “guest”, whose suid is -1 and whose uid is 2; and “public”, whose suid is -2 and whose uid is 0. In addition, both system-defined and user-defined roles are listed in sysusers.

The user “guest” provides a mechanism for giving users not explicitly listed in sysusers access to the database with a restricted set of permissions. The “guest” entry in master means any user with an account on Adaptive Server (that is, with an entry in syslogins) can access master.

The user “public” refers to all users. The keyword public is used with the grant and revoke commands to signify that permission is being given to or taken away from all users.

Indexes





Copyright © 2005. Sybase Inc. All rights reserved. sysxtypes

View this book as PDF