Monday, October 12, 2020

How to permission to one user to another user in oracle database

SQL> conn apex_200100/Abcd_1234

ERROR:

ORA-28000: The account is locked.



Warning: You are no longer connected to ORACLE.

SQL>

SQL>

SQL>

SQL> conn sys as sysdba

Enter password:

Connected.

SQL>

SQL>

SQL> alter user apex_200100 identified by Abcd_1234;


User altered.


SQL> alter user apex_200100 identified by Abcd_1234 account unlock;


User altered.


SQL> conn apex_200100/Abcd_1234@orcl19c

Connected.

SQL>

grant select, insert, update, delete on wwv_flow_list_items to ipihr


No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...