How to Create Index for Other User's Tableby Ed ChenJune 13, 2020October 24, 2021The answer is positive, you can create indexes for tables belonging to other users in your own schema, but you need more privileges. Try the… Read More »How to Create Index for Other User's Table
How to Resolve ORA-04043: object does not existby Ed ChenDecember 30, 2017May 13, 2022ORA-04043 ORA-04043 means that the schema object that you want to use is not existing, this could be a typo, privilege or case-sensitive problem like… Read More »How to Resolve ORA-04043: object does not exist
How to Grant Multiple Object Privileges in One Statementby Ed ChenJanuary 19, 2013June 27, 2022You don't have to grant object privileges line by line, they can be merged into one statement under some conditions. Here are some cans and… Read More »How to Grant Multiple Object Privileges in One Statement