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

Horizontal Scaling vs Vertical Scaling

 একটা application হঠাৎ করে অনেক বেশি user পেতে শুরু করল। আগে যেখানে ১,০০০ জন user ছিল, এখন সেখানে ১ লাখ user! তখন স্বাভাবিকভাবেই প্রশ্ন আসে—...