Upgrade failing with error ORA-01749: you may not GRANT/REVOKE privileges to/from yourself (Doc ID 2885043.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Elapsed: 00:00:00.01
16:49:11 SQL>
16:49:11 SQL> REM Bug27045057: revoke privileges granted using blessUser
16:49:11 SQL> REM Must be called after upgrade action of bug 27045090(above)
16:49:11 SQL>
16:49:11 SQL> declare
16:49:11 2 cursor s_c is select distinct schema_name from sys.dbfs_sfs$_tab;
16:49:11 3 lschema varchar2(128);
16:49:11 4 suid varchar2(512);
16:49:11 5 begin
16:49:11 6 for s_c_rec in s_c LOOP
16:49:11 7 suid := dbms_assert.enquote_name(s_c_rec.schema_name, false);
16:49:11 8 begin
16:49:11 9 execute immediate 'revoke execute on dbms_dbfs_content_property_t '
16:49:11 10 || ' from ' || suid;
16:49:11 11 exception
16:49:11 12 when others then
16:49:11 13 if sqlcode in ( -04042, -1927 ) then NULL;
16:49:11 14 else raise;
16:49:11 15 end if;
16:49:11 16 end;
16:49:11 17
16:49:11 18 begin
16:49:11 19 execute immediate 'revoke execute on dbms_dbfs_content_properties_t '
16:49:11 20 || ' from ' || suid;
16:49:11 21 exception
16:49:11 22 when others then
16:49:11 23 if sqlcode in ( -04042, -1927 ) then NULL;
16:49:11 24 else raise;
16:49:11 25 end if;
16:49:11 26 end;
16:49:11 27
16:49:11 28 begin
16:49:11 29 execute immediate 'revoke execute on dbms_dbfs_content_context_t '
16:49:11 30 || ' from ' || suid;
16:49:11 31 exception
16:49:11 32 when others then
16:49:11 33 if sqlcode in ( -04042, -1927 ) then NULL;
16:49:11 34 else raise;
16:49:11 35 end if;
16:49:11 36 end;
16:49:11 37
16:49:11 38 begin
16:49:11 39 execute immediate 'revoke execute on dbms_dbfs_content_raw_t '
16:49:11 40 || ' from ' || suid;
16:49:11 41 exception
16:49:11 42 when others then
16:49:11 43 if sqlcode in ( -04042, -1927 ) then NULL;
16:49:11 44 else raise;
16:49:11 45 end if;
16:49:11 46 end;
16:49:11 47
16:49:11 48 begin
16:49:11 49 execute immediate 'revoke execute on dbms_fuse '
16:49:11 50 || ' from ' || suid;
16:49:11 51 exception
16:49:11 52 when others then
16:49:11 53 if sqlcode in ( -04042, -1927 ) then NULL;
16:49:11 54 else raise;
16:49:11 55 end if;
16:49:11 56 end;
16:49:11 57
16:49:11 58 begin
16:49:11 59 execute immediate 'revoke execute on dbms_dbfs_sfs '
16:49:11 60 || ' from ' || suid;
16:49:11 61 exception
16:49:11 62 when others then
16:49:11 63 if sqlcode in ( -04042, -1927 ) then NULL;
16:49:11 64 else raise;
16:49:11 65 end if;
16:49:11 66 end;
16:49:11 67 end LOOP;
16:49:11 68 commit;
16:49:11 69 end;
16:49:11 70 /
declare
*
ERROR at line 1:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
ORA-06512: at line 14
ORA-06512: at line 14
ORA-06512: at line 9

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.