Posted on 2006-12-11 13:20
RedWolf 阅读(310)
评论(0) 编辑 收藏 所属分类:
测试管理工具
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;