Symptom
- Roles are used to simplify the granting of rights to users, as privileges and permissions granted to a role are inherited by users who belong to that group or incarnate that role.
- Cannot generate the NOT IDENTIFIED/IDENTIFIED clause of an Oracle role.
- The Oracle syntax to create a role is
CREATE ROLE role
[ NOT IDENTIFIED
| IDENTIFIED { BY password
| USING [ schema. ] package
| EXTERNALLY
| GLOBALLY
}
] [ CONTAINER = { CURRENT | ALL } ] ;
- The NOT IDENTIFIED clause indicates that this role is authorized by the database and that no password is required to enable the role.
- The IDENTIFIED clause indicates that a user must be authorized by the specified method before the role is enabled with the SET ROLE statement.
Read more...
Environment
- SAP PowerDesigner (PD) 16.5
- SAP PowerDesigner (PD) 16.6
- Oracle DBMS
Product
SAP PowerDesigner 16.6
Keywords
user, 808501, CR808501, CR#808501 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.