grants not imported

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 - 10:18:16 CDT