Technical Notes

Preparation " employees " table exists in HR schema " v_employees " view exists in HR2 schema; SQL> grant select ...

Error ORA-01045: user HR lacks CREATE SESSION privilege; logon denied Solution Grant CREATE SESSION privilege to 'HR' user SQL...

check own  privileges: SQL>   SELECT * FROM SESSION_PRIVS; syntax of  system privileges: GRANT [ system_privileges | roles] {ANY} ...