GRANT execute on sys.dbms_sql TO system with admin option;
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: GRANT execute on sys.dbms_sql TO system with admin option;

  1. #1
    Join Date
    Aug 2000
    Posts
    143
    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
    Location
    Mesa, Arizona
    Posts
    1,204
    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