当前在线人数12496
首页 - 分类讨论区 - 电脑网络 - 数据库版 -阅读文章
未名交友
[更多]
[更多]
文章阅读:Re: 怎么设置多个用户 (Oracle 10g)?
[同主题阅读] [版面: 数据库] [作者:fengbright] , 2007年03月17日09:58:09
fengbright
进入未名形象秀
我的博客
[上篇] [下篇] [同主题上篇] [同主题下篇]

发信人: fengbright (Aliang), 信区: Database
标  题: Re: 怎么设置多个用户 (Oracle 10g)?
发信站: BBS 未名空间站 (Sat Mar 17 09:58:09 2007)

1. assume user A created myjunktable
2. user A, or SYSDBA, or other users who have been granted select privilege
with grant option on this table can grant the select privilege to other
users
3. put schema in the grant command like
GRANT SELECT ON A.myjunktable to johndoe;
4. test it by using SELECT command after you login as johndoe

good luck
--

※ 来源:·BBS 未名空间站 http://mitbbs.com·[FROM: 209.91.]

[上篇] [下篇] [同主题上篇] [同主题下篇]
[转寄] [转贴] [回信给作者] [修改文章] [删除文章] [同主题阅读] [从此处展开] [返回版面] [快速返回] [收藏] [举报]
 
回复文章
标题:
内 容:

未名交友
将您的链接放在这儿

友情链接


 

Site Map - Contact Us - Terms and Conditions - Privacy Policy

版权所有,未名空间(mitbbs.com),since 1996