Oracle Database Errors or Warnings from Error ORA-28154 to ORA-28168

SQLServerF1

ORA-28154: Proxy user may not act as client ‘string’
Cause: A proxy user may not assume the identity of a privileged user in order to limit the privileges that a proxy may possess.
Action: Execute the statement again specify a client other than a privileged user.
ORA-28155: user ‘string’ specified as a proxy is actually a role
Cause: A user specified in an AUDIT <operation> BY <proxy> ON BEHALF OF <client> is actually a role.
Action: Execute the statement again with a valid proxy user.
ORA-28156: Proxy user ‘string’ not authorized to set role ‘string’ for client ‘string’
Cause: A proxy user has not been granted the right to use a role on behalf of a client.
Action: Execute the command ALTER USER <client> GRANT CONNECT THROUGH PROXY <proxy> to grant the needed role.

ORA-28157: Proxy user ‘string’ forbidden to set role ‘string’ for client ‘string’
Cause: A proxy user was forbidden to use a role on behalf of a client through the command ALTER USER <client> GRANT CONNECT THROUGH <proxy> WITH ALL ROLES EXCEPT <role>
Action: Execute the command ALTER USER <client> GRANT CONNECT THROUGH PROXY <proxy> to grant the needed role.
ORA-28163: GRANT already specified
Cause: The GRANT clause was specified twice.
Action: Use only one GRANT clause.
ORA-28164: REVOKE already specified
Cause: The REVOKE clause was specified twice.
Action: Use only one REVOKE clause.

ORA-28165: proxy ‘string’ may not specify password-protected role ‘string’ for client ‘string’
Cause: A proxy user attempted to activate a role on behalf of a client which has a password associated with it. Since the proxy does not have a password, this activation cannot be allowed.
Action: Attempt to activate a different role or change the role administratively so that there is no password.
ORA-28166: duplicate rolename in list
Cause: The name of a role was specified more than once in a list.
Action: Repeat the command specifying the role once.
ORA-28168: attempted to grant password-protected role
Cause: An ALTER USER … GRANT CONNECT command was attempted specifying a role that is protected by a password as a role which the proxy may execute on behalf of a client.
Action: Either specify a role that does not have a password or alter the role so that a password is not required.

Above are list of Oracle Database Errors or Warnings from Error ORA-28154 to ORA-28168 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *