软件测试+JAVA

-- 新手上路
posts - 13, comments - 7, trackbacks - 0, articles - 0

导航

<2006年12月>
262728293012
3456789
10111213141516
17181920212223
24252627282930
31123456

常用链接

留言簿(2)

随笔分类

随笔档案

相册

收藏夹

搜索

  •  

最新评论

阅读排行榜

评论排行榜

http://kb-index.mercury.com/web/queries/KBAview.asp?Product=TD&Conceptid=7145&BVUserID=


Solution: Checking permissions of an Oracle user for creating TD projects

Note:
Please have your Oracle DBA check this for you.

To check whether a user has the right privileges to create projects, log into SQL Plus as user "projadmin" and execute the following:

create user trial_user identified by (default password); (please contact Mercury support for the default password)
grant connect,resource to trial_user;
select username, sum(decode(privilege, 'SELECT ANY TABLE', 2, 'CREATE SESSION',1, 0)) from session_privs, user_users where privilege in ('SELECT ANY TABLE', 'CREATE SESSION') group by username

If these execute successfully, you can drop the user:

drop user trial_user;





只有注册用户登录后才能发表评论。


网站导航:
博客园   IT新闻   Chat2DB   C++博客   博问