Re: grants not imported

You had to give these privs as SYS, not SYSTEM, didn't you? The user SYS is not included in the full export since it is supposed to only contain the catalog etc.... The administration of the database should not be imported for obvious reasons.
As a result grants given by SYS are not in the full export.

Here is the main reason why Oracle says not to created your objects in SYS. There are more "administrative accounts" that are never exported. See Utliities Guide.

Peter Laursen <ptl_at_edbgruppen.dk> schreef in berichtnieuws 3d9324dc$0$69022$edfadb0f_at_dspool01.news.tele.dk...
| System 8.0.5 through 8.1.7.4.1
|
| One oracle user has been granted select on dba_data_files and dba_extents.
| The grants are direct not through a role. When doing a full export and
| import as system these grants are not carried over with the import.
|
| The purpose of the grants is to do this select:
| select
| a.tablespace_name,a.bytes_full,b.bytes_total,a.bytes_full/b.bytes_total
| status, b.bytes_total-a.bytes_full free
| from
| (select tablespace_name,sum(bytes) bytes_full from dba_extents where
| tablespace_name='HBMSTAB' group by tablespace_name) a,
| (select tablespace_name,sum(bytes) bytes_total from dba_data_files where
| tablespace_name='HBMSTAB' group by tablespace_name) b
| where a.tablespace_name=b.tablespace_name
|
| Do I have to make the grants everytime I do an import?
|
| TIA
| Peter Laursen
|
|
Received on Thu Sep 26 2002 - 13:58:01 CDT