Hi, All
We have an application user who was granted all privileges.
This user owns the application therefore all other users were created under its schema.
The same application user is created on production and test database.
When you logon the production database with that user and password you can create other users and grant privilege with no
problem.
BUT
when you try to create other users with the same application user
on the test database we are getting ORA-00990- Missing or invalid
privilege.
We compared the privileges of the two databases and we find out that the Test database has the following privileges granted
ADMINISTER RESOURCE MANAGER
ALTER OPERATOR
DEQUEUE ANY QUEUE
ENQUEUE ANY QUEUE
EXTENDS ANY TYPE
EXTENDS TYPE
MANAGE ANY QUEUE.
The above privileges are not on the production database therefore NO problem with creating users on the Production.
We are a little skeptical in droping the application user on the TEST database and recreate it.
We also attemped to revoke those privileges and getting the same error. (Invalid or missing privilege)
What 's the reprecaution of login as INTERNAL and drop the application user cascade that owns all the tables & recreate it ?
Please advise
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.