SAP Knowledge Base Article - Preview

2481956 - Cannot generate the NOT IDENTIFIED/IDENTIFIED clause of an Oracle role - SAP PD

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.