eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To: eygle
　　知道你曾经搞过oracle erp，所以特意请教一个问题！
我现在用erp德inv用户，按用户导出了他的所有objects,然后drop user cascade,然后重新创建user,然后授权
grant execute on AD_DDL to INV;
-- Grant/Revoke system privileges
grant alter any outline to INV;
grant alter session to INV;
grant analyze any to INV;
grant create any outline to INV;
grant create cluster to INV;
grant create database link to INV;
grant create sequence to INV;
grant create session to INV;
grant create snapshot to INV;
grant create table to INV;
grant create type to INV;
grant drop any outline to INV;
grant query rewrite to INV;
grant create session to INV;
grant create synonym to INV;
grant create view to INV;
grant create procedure to INV;
grant create trigger to INV
然后倒入，可是却提示我：
IMP-00015: following statement failed because the object already exists:
"CREATE package APPS_DDL AUTHID DEFINER as"
"/* $Header: adaddls.pls 115.1 99/07/17 04:29:35 porting ship $ */"
" --"
" -- Package"
" -- APPS_DDL"
" -- Purpose"
" -- Dynamic DDL support"
" -- Notes"
" -- 1. This package is created in each Oracle Applications account"
" -- 2. Each account requires the following explicit"
" --privileges to run (i.e. these privileges cannot be obtained"
" --from a role, like 'connect'):"
" --grant create session to <schema>;"
" --grant alter session to <schema>;"
" -- grant create database link to <schema>;"
" -- grant create synonym to <schema>;"
" -- grant create view to <schema>;"
" -- grant create cluster to <schema>;"
" -- grant create procedure to <schema>;"
" -- grant create sequence to <schema>;"
" -- grant create table to <schema>;"
" -- grant create trigger to <schema>;"
" -- Currently AutoInstall grants the neccessary privs to each schema"
" --"

"procedure apps_ddl(ddl_text in varchar2);"
"end APPS_DDL;"
Import terminated successfully with warnings.

但是我明明已经把提示中的权限都授权了呀！
而且我察看其他没有问题的环境，用户的权限也就是下面的这些：
alter any outline
alter session
analyze any
create any outline
create cluster
create database link
create sequence
create session
create snapshot
create table
create type
drop any outline
query rewrite
我给这个有问题的环境的inv账户提供的权限比上面这个还多，则么会提示没有权限呢？郁闷！
我后来grant conenct,resource to inv,在实验的话就没有问题，但是我觉得系统中之所以没有connect,resouce的角色，肯定有它的道理，所以我想请教为何我上面的方法不可以？]
谢谢啦！]

From: Remen
2005.07.19 17:27