Show TOC

Users, Groups, and Roles (PDM)Locate this document in the navigation structure

A user is a database object that identifies a person who can login or connect to the database. Groups and roles are used to simplify the granting of rights to users, as privileges and permissions granted to a group or role are inherited by users who belong to that group or incarnate that role.

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

Note For many DBMSs, users can have an implicit schema, and PowerDesigner can reverse-engineer create statements contained within a schema. For SQL Server 2005 and higher, where users can have multiple schemas, PowerDesigner reverse-engineers schemas as separate objects (see Schemas (SQL Server)).