Users, roles and privileges in Oracle. Privileges. A privilege is a right to execute an SQL statement or to access another user's object. In Oracle, there are two types of privileges: system privileges and object privileges. A privileges can be assigned to a user or a role. The set of privileges is fixed, that is, there is no SQL statement like create privilege xyz...