0

I am trying to apply a role to a user and getting this error: SQL Error: ORA-00990: missing or invalid privilege. Here is where I created the role, which worked fine logged in as SYSTEM.

    CREATE ROLE LahmanDBDev;
    GRANT CREATE SESSION TO LahmanDBDev;
    GRANT CREATE TABLE TO LahmanDBDev;
    GRANT CREATE TABLESPACE TO LahmanDBDev;
    GRANT CREATE VIEW TO LahmanDBDev;
    GRANT CREATE ANY INDEX TO LahmanDBDev;
    GRANT CREATE SEQUENCE TO LahmanDBDev;
    GRANT CREATE SYNONYM TO LahmanDBDev;
    GRANT SELECT ON BASEBALL.MASTER TO LahmanDBDev;
    GRANT SELECT ON BASEBALL.BATTING TO LahmanDBDev;
    GRANT SELECT ON BASEBALL.FIELDING TO LahmanDBDev;

Then I went on to create the user and grant the role to it, the second statement here where I grant the role is where I get the error:

    CREATE USER BudSelig
    IDENTIFIED BY BudSelig;

    GRANT ROLE LahmanDBDev
    TO BudSelig;

closed as off-topic by Paul White, Max Vernon, Kin Shah, RolandoMySQLDBA, Aaron Bertrand May 8 '14 at 21:58

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Paul White, Max Vernon, Kin Shah, RolandoMySQLDBA, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

2

The correct syntax is:

   GRANT LahmanDBDev
   TO BudSelig;
  • Thanks, feeling pretty dumb right now but i knew it was something simple. – user2884621 May 6 '14 at 12:28

Not the answer you're looking for? Browse other questions tagged or ask your own question.