14eer

0 积分	1 好友	14 主题

发消息

[ORA-600/ORA-7445] 单机9I升级10GRAC用户权限及原密码问题

1^#

发表于 2013-5-12 14:12:40 | 查看: 3653| 回复: 5

大家好，
         月末会将一套生产系统由目前在WINDOWS 9I单机环境迁移到 10G LINUX RAC 环境，定的方案是将所有用户的数据EXP导出，然后再新库IMP导入，现在遇到的问题是:
                     1、这个库并不大但是用户很多大概300多，在我迁移以后怎么保证所有用户的权限也迁过来还是在这边再授权如果原来的库有自建的角色怎么办，这是第一个搞不懂的问题。
                     2、怎么保证新库的用户密码和原来库用户的密码是一样的，不可能在这新库给用户设置密码因为厂商已经弃管问不出来密码了。请刘大和各位指点一下

分享0

收藏0 回复只看该作者道具举报

harryzhang

2^#

发表于 2013-5-12 20:02:38

你可以参考ASKTOM。
曾经也有人问了。。

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:494205100346718343

回复只看该作者道具举报

harryzhang

3^#

发表于 2013-5-12 20:03:15

select (case
      when ((select count(*)
            from dba_users
            where  username = '&&Username') > 0)
      then  dbms_metadata.get_ddl ('USER', '&&Username')
      else  to_clob (' -- Note: User not found!')
      end ) Extracted_DDL from dual
UNION ALL
select (case
      when ((select count(*)
            from dba_ts_quotas
            where  username = '&&Username') > 0)
      then  dbms_metadata.get_granted_ddl( 'TABLESPACE_QUOTA', '&&Username')
      else  to_clob (' -- Note: No TS Quotas found!')
      end ) from dual
UNION ALL
select (case
      when ((select count(*)
            from dba_role_privs
            where  grantee = '&&Username') > 0)
      then  dbms_metadata.get_granted_ddl ('ROLE_GRANT', '&&Username')
      else  to_clob (' -- Note: No granted Roles found!')
      end ) from dual
UNION ALL
select (case
      when ((select count(*)
            from dba_sys_privs
            where  grantee = '&&Username') > 0)
      then  dbms_metadata.get_granted_ddl ('SYSTEM_GRANT', '&&Username')
      else  to_clob (' -- Note: No System Privileges found!')
      end ) from dual
UNION ALL
select (case
      when ((select count(*)
            from dba_tab_privs
            where  grantee = '&&Username') > 0)
      then  dbms_metadata.get_granted_ddl ('OBJECT_GRANT', '&&Username')
      else  to_clob (' -- Note: No Object Privileges found!')
      end ) from dual
/

----------------------分割线------------------------

EXTRACTED_DDL
--------------------------------------------------------------------------------

CREATE USER "XYZ" IDENTIFIED BY VALUES 'C4634D0ED8A90B04'
   TEMPORARY TABLESPACE "TEMP"

ALTER USER "XYZ" QUOTA 12800 ON "SYSTEM"

GRANT "RESOURCE" TO "XYZ"

  GRANT CREATE SESSION TO "XYZ"

  GRANT ALTER ON "SYS"."AUD$" TO "XYZ"

  GRANT DELETE ON "SYS"."AUD$" TO "XYZ"

  GRANT INDEX ON "SYS"."AUD$" TO "XYZ"

  GRANT INSERT ON "SYS"."AUD$" TO "XYZ"

  GRANT SELECT ON "SYS"."AUD$" TO "XYZ"

  GRANT UPDATE ON "SYS"."AUD$" TO "XYZ"

  GRANT REFERENCES ON "SYS"."AUD$" TO "XYZ"

  GRANT ON COMMIT REFRESH ON "SYS"."AUD$" TO "XYZ"

  GRANT QUERY REWRITE ON "SYS"."AUD$" TO "XYZ"

  GRANT DEBUG ON "SYS"."AUD$" TO "XYZ"

  GRANT FLASHBACK ON "SYS"."AUD$" TO "XYZ"

回复只看该作者道具举报