Roles

Go Up to Supported Objects

Roles are sets of user privileges you associate with access to objects within a database. Roles streamline the process of granting permissions. You can use roles to grant sets of permissions and privileges to users and groups.

Creating and editing

• Roles Wizard (SQL Server) and Roles Editor (SQL Server)
• Roles Wizard (Oracle) and Roles Editor (Oracle)
• Roles Wizard (PostgreSQL) and Roles Editor (PostgreSQL)

• Role Wizard (Sybase ASE) and Roles Editor (Sybase ASE)

DBMS platform availability and object actions/operations supported

The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.

	ORCL	PSTGRS *	SQL SVR	SYB ASE
Create Like		✓
Drop	✓	✓	✓	✓
Extract	✓	✓	✓	✓
Migrate	✓		✓	✓
Rename		✓
Report	✓		✓	✓
Role Activation	✓			✓

Topics

• Microsoft SQL Server Roles
• Oracle Roles

• Sybase ASE Roles
• Server Roles