Oracle 8.1.7.2
I just noticed that a full export of a database does not contain any grants
on SYS's objects. Is this expected/documented behavior (I haven't found it
documented in any manual)? I know that a full export/import does not import
SYS objects but is it supposed to ignore the grants on those objects too? I
have numerous databases where users need EXECUTE and SELECT privileges on
some of SYS's objects. If I were to restore those databases from a full
export they would be screwed up. Is there an option to force the grants to
be exported, or some other workaround apart from having to export them
manually?
Received on Thu Jul 18 2002 - 12:12:46 CDT
