请问如何用一个语句取消所有用户和角色的权限？(50分)

M

mycwcgr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-20

• #1

请问如何用一个语句取消所有用户和角色的权限？

使用下面的语句可以取消用户和角色的权限
Revoke all on my_table from myrole1,myrole2,group1,...
如果用户很多的话将非常麻烦，请问如何用一个语句取消所有用户和角色的权限？

 

M

mycwcgr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-20

• #2

注意：上面需要在 Delphi 中用编程实现

 

W

WebExplorer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-20

• #3

使用临时表

 

M

mycwcgr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-20

• #4

to WebExplorer:
How to use temp table?

 

D

dopro

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-22

• #5

revoke connect from public;
revoke resource from public;
recoke dba from public

 

M

mycwcgr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-22

• #6

dopro, 时间：2002-9-22 9:39:00, ID：1339140
revoke connect from public;
revoke resource from public;
recoke dba from public
您能解释一下吗？

 

D

dopro

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-23

• #7

写错了，应该是
revoke all on connect from public;
revoke all on resource from public;
recoke all on dba from public

 

M

mycwcgr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-23

• #8

revoke all on connect from public;
revoke all on resource from public;
recoke all on dba from public
对吗？

recoke all on dba from public
这是取消什么表的DBA?

revoke all on connect from public;
这是取消组PUBLIC对于表connect的权限吗？

 

M

mycwcgr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-26

• #9

接受答案了.