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.
SAP Knowledge Base Article - Preview