0 Replies Latest reply on Apr 16, 2019 10:24 AM by Matthias Hoys

    SQL Developer 19.1 - incorrect user ddl from DBA view

    Matthias Hoys

      Hi,

       

      I noticed the following issue in SQL Developer 19.1 (I believe it's also present in 18.4):

      - go to the DBA view

      - open Security => Users

      - right-click on a user account => Create Like...

      - fill in a user name and check the option "Copy Object Privileges"

      - if you now look at the output in the SQL tab you will see that the object privileges statements are incorrectly generated (the user is in front of each line instead of at the back):

       

      "newuser"GRANT EXECUTE ON "SYS"."UTL_SMTP" TO ;

      "newuser"GRANT EXECUTE ON "SYS"."UTL_URL" TO ;

      "newuser"GRANT EXECUTE ON "SYS"."UTL_ENCODE" TO ;

      "newuser"GRANT EXECUTE ON "SYS"."UTL_LMS" TO ;

       

      Is this a known bug?

       

      Regards

      Matthias