Grant Create Index to User?by Ed ChenJune 13, 2020May 26, 2023CREATE INDEX Privilege? Tried to grant a CREATE INDEX system privilege to an user, it failed with ORA-00990. SQL> grant create index to oe; grant… Read More »Grant Create Index to User?
How to Resolve ORA-04043: object does not existby Ed ChenDecember 30, 2017April 19, 2023ORA-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