ORACLE SEQUENCE的简单介绍

如何修改sequence的权限(将用户aaa下的sequence查询权限分配给用户bbb)：

conn aaa/aaa
grant select on sequencename to bbb
conn bbb/bbb
select aaa.sequencename.nextval from dual

授予和收回权限

grant select on seq_teammember_id to aaa

revoke select on seq_teammember_id from bbb

原文来自：雨枫技术教程网 http://www.fengfly.com
原文网址：http://www.fengfly.com/plus/view-168639-1.html