ORA-00991: only MAC privileges may be granted to procedures
Cause: Object privileges or non-MAC system privileges were granted to the procedure
Action: Only grant MAC privileges using the PROCEDURE clause
All posts by mpbod
ORA-00990: missing or invalid privilege
ORA-00990: missing or invalid privilege
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
ORA-00989: too many passwords for usernames given
ORA-00989: too many passwords for usernames given
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
ORA-00988: missing or invalid password(s)
ORA-00988: missing or invalid password(s)
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
ORA-00987: missing or invalid username(s)
ORA-00987: missing or invalid username(s)
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
ORA-00986: missing or invalid group name(s)
ORA-00986: missing or invalid group name(s)
Cause: Probably a syntax error
Action: Correct syntax
ORA-00985: invalid program name
ORA-00985: invalid program name
Cause: Probably a syntax error
Action: Correct syntax
ORA-00984: column not allowed here
ORA-00984: column not allowed here
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
ORA-00983: cannot audit or noaudit SYS user actions
ORA-00983: cannot audit or noaudit SYS user actions
Cause: An attempt was made to AUDIT or NOAUDIT SYS user actions
Action: Execute the statement again with a valid user
ORA-00982: missing plus sign
ORA-00982: missing plus sign
Cause: A left parenthesis appeared in a join condition, but a plus sign (+) did not follow. A left parenthesis in a join condition usually signals an outer-join specification and so a plus sign is expected to follow. To specify an outer join on a column in a join operation, follow the column reference in the join condition with a plus sign (+) enclosed in parentheses
Action: Correct the SQL syntax and retry the statement