留言簿 - Oracle Life - Powered by Eygle.com

eygle.com	我要留言
新书《循序渐进Oracle》即将出版

昵称

内容	页: 1 - << < 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 > >> - 404

# 921

Rose

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) 221.216.60.*

To:
　　＂五一＂的期盼与结束匆匆而去，并没有太多的感觉，也许是岁月的痕迹感觉成熟了很多．只是想下一个＂五一＂也许会同样的无模３Ｏ耄貉≡裎蠢词切枰缕模衷诰醯醚≡褡约合胍纳钔枰缕弊约喝肥蹬α耍簿臀蘩⒂诠匦墓呐笥蚜耍驯静皇粲谧约旱姆孔映沟姿⒘艘槐椋残砟芨亲⊥盏男了岚桑有驴迹罨岷苊篮茫槲业娜匀皇亲约合肟吹暮纾�

From: Rose
2005.05.07 22:29

To: Rose
　　[COLOR=blue]生活随意就好，只要认真经历，平淡何尝不是美丽[/COLOR]

From: eygle
2005.05.08 17:46

版主选项:

编辑

# 920

lily

Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) 202.108.244.*

To: eygle
　　美好的假期终究是结束了又得奔命工作了遥远的”十一“期待你

From: lily
2005.05.07 18:28

To: lily
　　[COLOR=blue]俺马上就可以休假，又可以来一次长途旅行了[/COLOR]

From: eygle
2005.05.08 17:43

版主选项:

编辑

# 919

Sabrina

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; MyIE2; TencentTraveler ) 219.142.133.*

To:
　　明天就又离开北京了,不知道再见面是什么时候

From: Sabrina
2005.05.07 09:07

To: Sabrina
　　[COLOR=blue]也许用不了多久[/COLOR]

From: eygle
2005.05.08 17:42

版主选项:

编辑

# 918

remen

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) 221.194.3.*

To:
　　好像出错了：
ORA-25191: cannot reference overflow table of an index-organized table
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1474
ORA-06512: at line 9

From: remen
2005.05.07 01:49

To: remen
　　[COLOR=blue]
这个错误表明你授权的对象包含IOT OVERFLOW表，对于IOT表只需要对父表进行授权即可，修改一下就是:

declare
sqltext varchar2(200);
c integer;
begin
for userlist in (select user_id,username from all_users where username not in ('SYS','SYSTEM','EYGLE'

) loop
for tablelist in (select owner,table_name from dba_tables where owner = userlist.username and table_name not like '%IOT_OVER%'

loop
sqltext := 'grant all on '||tablelist.owner||'.'||tablelist.table_name ||' to eygle with grant option';
c := sys.dbms_sys_sql.open_cursor();
sys.dbms_sys_sql.parse_as_user( c,sqltext,dbms_sql.native,userlist.user_id);
sys.dbms_sys_sql.close_cursor(c);
end loop;
end loop;
end;
/

[/COLOR]

From: eygle
2005.05.07 02:20

版主选项:

编辑

# 916

Remen

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) 221.194.3.*

To: eygle
　　老虎，帮帮忙吧，我们现在用的是oracle erp ,db 8174
现在我想吧所与owner得table的所有权付给apps，并授权grant权限，但是就是不知道执行sqlplus得时候应该用那个用户执行？apps我也试过了，提示不能授权给自己
脚本如下：
$vi b.sql
declare username varchar2(100) default 'SYS';
begin
for tablelist in (select owner,table_name from dba_tables
 where owner not in ('SYS','SYSTEM','APPS'

order by 1 )
loop
if tablelist.owner<> username then
execute immediate 'alter session set current_schema = '||tablelist.owner||'';
username = tablelist.owner;
end if;
execute immediate 'grant all on '||tablelist.owner||'.'||tablelist.table_name ||' to apps with grant option';
end loop;
end;
/
$svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> @b.sql
ORA-01929: no privileges to GRANT
ORA-06512: at line 10
SVRMGR>
$ sqlplus apps/apps@b.sql

SQL*Plus: Release 8.1.7.0.0 - Production on Fri May 6 13:47:42 2005

(c) Copyright 2000 Oracle Corporation.All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

declare username varchar2(100) default 'SYS';
*
ERROR at line 1:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
ORA-06512: at line 10

From: Remen
2005.05.05 22:43

To: Remen
　　[COLOR=blue]
使用dbms_sys_sql就可以了，写个完整的例子给你:

declare
sqltext varchar2(200);
c integer;
begin
for userlist in (select user_id,username from all_users where username not in ('SYS','SYSTEM','EYGLE'

) loop
for tablelist in (select owner,table_name from dba_tables where owner = userlist.username) loop
sqltext := 'grant all on '||tablelist.owner||'.'||tablelist.table_name ||' to eygle with grant option';
c := sys.dbms_sys_sql.open_cursor();
sys.dbms_sys_sql.parse_as_user( c,sqltext,dbms_sql.native,userlist.user_id);
sys.dbms_sys_sql.close_cursor(c);
end loop;
end loop;
end;
/

[/COLOR]

From: eygle
2005.05.06 18:09