Вопрос:
При импорте из дампа, база как-то криво работает...
Ответ:
Наверное, забыли права додать, пропадающие при импорте.

ALTER USER SUPERMAG DEFAULT ROLE SUPERMAG_USER;
GRANT ADMINISTER DATABASE TRIGGER TO SUPERMAG;
GRANT ALTER ANY ROLE TO SUPERMAG;
GRANT ALTER ANY ROLE TO SUPERMAG WITH ADMIN OPTION;
GRANT ALTER SYSTEM TO SUPERMAG;
GRANT ALTER USER TO SUPERMAG WITH ADMIN OPTION;
GRANT ANALYZE ANY TO SUPERMAG;
GRANT CREATE ANY INDEX TO SUPERMAG;
GRANT CREATE CLUSTER TO SUPERMAG;
GRANT CREATE DATABASE LINK TO SUPERMAG;
GRANT CREATE LIBRARY TO SUPERMAG;
GRANT CREATE PROCEDURE TO SUPERMAG;
GRANT CREATE PUBLIC SYNONYM TO SUPERMAG;
GRANT CREATE ROLE TO SUPERMAG;
GRANT CREATE ROLE TO SUPERMAG WITH ADMIN OPTION;
GRANT CREATE SEQUENCE TO SUPERMAG;
GRANT CREATE SESSION TO SUPERMAG;
GRANT CREATE SESSION TO SUPERMAG_USER;
GRANT CREATE SNAPSHOT TO SUPERMAG;
GRANT CREATE TABLE TO SUPERMAG;
GRANT CREATE TRIGGER TO SUPERMAG;
GRANT CREATE USER TO SUPERMAG WITH ADMIN OPTION;
GRANT CREATE VIEW TO SUPERMAG;
GRANT DROP ANY INDEX TO SUPERMAG;
GRANT DROP ANY ROLE TO SUPERMAG WITH ADMIN OPTION;
GRANT DROP PUBLIC SYNONYM TO SUPERMAG;
GRANT DROP USER TO SUPERMAG WITH ADMIN OPTION;
GRANT EXECUTE ON DBMS_ALERT TO SUPERMAG;
GRANT EXECUTE ON DBMS_LOCK TO SUPERMAG;
GRANT EXECUTE ON DBMS_PIPE TO SUPERMAG;
GRANT EXECUTE ON DBMS_UTILITY TO SUPERMAG WITH GRANT OPTION;
GRANT EXECUTE ON DBMS_OUTPUT TO SUPERMAG;
GRANT GLOBAL QUERY REWRITE TO SUPERMAG;
GRANT GRANT ANY ROLE TO SUPERMAG WITH ADMIN OPTION;
GRANT SELECT ON DBA_CONS_COLUMNS TO SUPERMAG WITH GRANT OPTION;
GRANT SELECT ON DBA_CONSTRAINTS TO SUPERMAG WITH GRANT OPTION;
GRANT SELECT ON DBA_JOBS TO SUPERMAG WITH GRANT OPTION;
GRANT SELECT ON DBA_ROLES TO SUPERMAG;
GRANT SELECT ON DBA_TAB_COLUMNS TO SUPERMAG WITH GRANT OPTION;
GRANT SELECT ON DBA_USERS TO SUPERMAG WITH GRANT OPTION;
GRANT SELECT ON V_$INSTANCE TO SUPERMAG;
GRANT SELECT ON V_$SESSION TO SUPERMAG WITH GRANT OPTION;
GRANT SELECT ON ALL_ARGUMENTS TO SUPERMAG WITH GRANT OPTION;
GRANT SUPERMAG_USER TO SUPERMAG;

в доке, которую раздает Сервис Плюс есть
GRANT SELECT ANY TABLE TO SUPERMAG;
grant select on dba_users to public;
но я бы это делать не стал...
тема по грантам и ролям Супермага