软件测试+JAVA

-- 新手上路
posts - 13, comments - 7, trackbacks - 0, articles - 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;





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


网站导航: