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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.