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

    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
    Location
    Oklahoma, USA
    Posts
    354
    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.

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

    JoeB

Posting Permissions

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