DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2000
    Does anyone know why this statement fails with this error.

    GRANT execute on sys.dbms_sql TO system with admin option
    ORA-00993: missing GRANT keyword

    Basically what im trying to do is create a shell script to create users with execute permissions on sys.dbms_sql. I dont mind specifying the system login details in the script but i dont really want to specify the sys password

  2. #2
    Join Date
    Mar 2002
    Mesa, Arizona
    The error text below implies that you're missing a ";" on the prior statement in your script.

    Error: ORA 993
    Text: missing GRANT keyword
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.