Complete Source for Oracle Error Code Ora-, Pl/Sql Tips and Tricks and Oracle Error Message Description
Cause : The keyword WITH was specified at the end of a GRANT statement without the keyword GRANT. To grant privileges to a user and the permission to grant those privileges to another user, you must specify the keywords WITH GRANT OPTION at the end of the GRANT statement.
Action : Change the keyword WITH to the keywords WITH GRANT OPTION, then retry the statement.
Popularity: 25% [?]
Cause : An invalid form of the REVOKE command was entered. There are two forms of the REVOKE command. The first form is used to revoke a user’s database access privileges. The second form is used to revoke a user’s object privileges.
Action : Check the command syntax and retry the statement.
Popularity: 17% [?]
Cause : Object privileges or non-MAC system privileges were granted to the procedure.
Action : Only grant MAC privileges using the PROCEDURE clause.
Popularity: 8% [?]
Cause : No privileges were specified in a GRANT privilege statement, or one of the specified privileges is invalid.
Action : Enter one or more valid privileges such as SELECT, INSERT, DELETE, UPDATE, ALTER, INDEX, REFERENCES, or ALL. More than one privilege may be granted by entering the privileges in a list separated by commas (,) or by specifying the keyword ALL to grant all privileges.
Popularity: 15% [?]
Cause : More passwords than usernames were specified in a GRANT statement. Only one password may be entered for each username listed in the GRANT statement.
Action : Enter an equal number of usernames and passwords.
Popularity: 9% [?]
Cause : More usernames than passwords were specified in a GRANT statement.
A valid password must be specified for each username listed in the GRANT statement.
Action : Enter a valid password for each username.
Popularity: 9% [?]
Cause : No username was specified in a GRANT statement or one of the specified usernames is invalid. Valid usernames must be specified following the keyword TO in a GRANT statement to define a user. A username must begin with a letter, consist only of alphanumeric characters and the special characters $, _, and #, and be less than or equal to 30 characters. If it contains other characters, it must be enclosed in double quotation marks. It may not be a
reserved word.
Action : Specify a valid username, or list of usernames, following the keyword TO in the GRANT statement.
Popularity: 12% [?]
Cause : Probably a syntax error.
Action : Correct syntax.
Popularity: 14% [?]
Cause: Probably a syntax error.
Action: Correct syntax.
Popularity: 12% [?]
Cause : A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.
Action : Check the syntax of the statement and use column names only where appropriate.
Popularity: 15% [?]
