Users (PDM)

A user is a database object that identifies a person who can login or connect to the database. Users may have:

a role that specifies their responsibilities (see Roles (PDM))
membership in a group that specifies their rights (see Groups (PDM))
privileges that control their level of access (see Granting system privileges)
permissions that allow them to perform actions on objects (see Granting object permissions)

Note:

Not all DBMSs support the concepts of user, role and group.

Creating a User
You can create a user in any of the following ways:
User Properties
You can modify an object's properties from its property sheet. To open a user property sheet, double-click its Browser entry in the Users folder. The following sections detail the property sheet tabs that contain the properties most commonly entered for users.
Assigning an Owner to an Object
In a database, the user who creates an object (tables, views, stored procedures, etc) is the owner of the object and is automatically granted all permissions on it.
Granting System Privileges
A system privilege is a set of rights assigned to a database user, group, or role. You use system privileges to create user profiles with different levels of influence over the database content.
Granting Object Permissions
Object permissions are operations attached to particular database objects.

Parent topic: Building a Database Access Structure

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com