Users, Groups, and Roles (PDM)

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.

• Creating a User, Group, or Role
  You can create a user, groupe or role from the Browser or Model menu.
• User, Group, and Role Properties
  To view or edit a user, group, or role's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• 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. The procedure for defining privileges is identical for users, groups, and roles.
• Granting Object Permissions
  Object permissions give users the right to perform operations on particular database objects. The procedure for defining permissions is identical for users, groups, and roles.
• Inserting a User into a Group
  Once you have created a group, you can insert users into it.
• Assigning a User to a Role
  Once you have created a role, you can assign users to it.