ORA-01435 user does not exist

What causes an ORA-01435 error?

This message is caused by any reference to a non-existent user. For example, it occurs if a SELECT, GRANT, or REVOKE statement specifies a username that does not exist. Only a GRANT CONNECT statement may specify a new username. All other GRANT and REVOKE statements must specify existing usernames. If specified in a SELECT statement, usernames must already exist.

How Xynomix can help

Specify only existing usernames in the SELECT, GRANT, or REVOKE statement or ask the database administrator to define the new username.

Contact us for more information. To learn more about ways we can support your database visit our Oracle database consultancy page.

Contact Us

    On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.

    “We have utilised Xynomix consultancy for multiple projects. Most recently we have enlisted their consultants help to complete an Oracle database migration to new servers. As part of this Xynomix used their specialist knowledge to set up an appropriate backup and data retention policy in line with industry best practice. The work was, as always, completed in a timely, efficient manner.”
    aston university