Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: grant all objects to system

    how can I grant on all objects permissions created by an owner at once
    to other user (i.e. system) so it can grant to others??
    Is it possible????

  2. #2
    Join Date
    Dec 2003
    Oklahoma, USA
    In Oracle, the only "ALL PRIVILEGES" granting that occur is only done on the object level. You can "GRANT ALL ON my_table TO another_user" and he will have all privs, but there is no way of granting privs on all objects owned by a user short of writing a little bit of SQL.

    set heading off;
    spool all.sql
    select 'GRANT ALL ON ' || object_name || ' TO another_user;' 
       FROM user_objects;
    spool off;
    By the way, this works for packages, procedures, functions, etc as well.


Posting Permissions

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