DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: privilege to issue grants??

  1. #1
    Join Date
    Oct 2000
    Posts
    103

    Question

    I am loggeg in as sys and when I try this command

    SQL> 2
    2* from dba_tab_grants
    SQL> grant select production.dws_contract_info to migrate with grant option;

    I get the following error

    ERROR at line 1:
    ORA-00990: missing or invalid privilege

    Shouldn't sys be able to do this??

  2. #2
    2 things

    1.-It's "GRANT SELECT ON"
    2.-Only the user owner of the object can grant privileges to others.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Jul 2000
    Posts
    53
    No.

    Unless object_owner has given privilege to sys with grant option.

    So login as that user and issue the statement and it will work.

    Regards,
    Steve

  4. #4
    Join Date
    Oct 2000
    Posts
    103
    Well thats what I thought to, so I tried it last night(and again just now)
    and got the same exact error???

  5. #5
    Join Date
    Jul 2000
    Posts
    53
    log on as production to the database

    then try
    grant select on dws_contract_info to migrate with grant option;

    regards,
    Steve

  6. #6
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Exactly, you should login as USER to grant permission of the users objects
    Thanks
    Kishore Kumar

  7. #7
    Join Date
    Oct 2000
    Posts
    103
    yes, I initialy logged in as the user but was unable to grant it so I tried as sys and got the same err, I have rebooted the server and all errors I was getting are gone.

    Thanks to all,
    SM

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