ORA-28023: must revoke grants of this role to other user(s)
first



ORA-28023: must revoke grants of this role to other user(s) first..

Answer / guest

Cause: The role altered to IDENTIFIED GLOBALLY was granted
to one or more other users and/or roles. Global roles cannot
be granted to any user or role.

Action: Use REVOKE to revoke the role from other users or
roles first.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-26670: STREAMS option requires COMPATIBLE parameter to be string or higher

1 Answers  


TNS-00011: INTCTL: error while starting the Connection Manager

1 Answers  


ORA-16715: Log transport related property string of standby "string" is inconsistent.

1 Answers  


ORA-27023: skgfqsbi: media manager protocol error

1 Answers  


PCC-02208: No filename specified in #include statement

1 Answers  






SQL*Loader-00937: parallel load requested and string has enabled triggers or constraints

1 Answers  


KUP-04083: no directory object specified in LOBFILE clause for column string

1 Answers  


ORA-10566: Test recovery has used all the memory it can use

1 Answers  


ORA-28556: authorization insufficient to access table

1 Answers  


ORA-01526: error in opening file 'string'

1 Answers  


ORA-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.

1 Answers  


TNS-04071: Connections closed successfully. Number closed: number.

1 Answers  


Categories