The reason why the system common user (users Group) cannot log on to oracle normally

Source: Internet
Author: User

The reason why a common user (users Group) cannot log on to oracle is a strange problem recently. In windows 2003, when the Administrator logs on to the system, if you use pl SQL dev to enter the account and password to log on to oracle, you can log on to oracle normally. However, if you use the 2003 system common user (users Group) to log on to the system, and then use pl SQL dev to log on to oracle, a blank error prompt box is displayed, only one OK button can be clicked. Why can't I log on. It is strange that, after the 2003 Administrator logs on to oracle, normal users can log on as long as the Administrator does not turn it off. Once the Administrator turns it off, normal users cannot log on again. If you use sqlplus to log on, the situation is similar. When you log on to a common user, sqlplus will flash through without any prompt. Later in cmd using sqlplus command login, finally found the error prompt: SP2-1503: Unable to initialize the oracle call interface; SP2-1502: oracle cannot work normally. Take this error message to Baidu. The answer is as follows. It turns out that common users in the system do not have the permission to Create global objects. You can solve this problem by clicking start ", point to programs, point to administrative tools, and click Local Security Policy ". Expand local policy, and then click User permission assignment ". In the right pane, double-click Create Global object ". In the Local Security Policy Settings dialog box, click Add ". In the select user or group dialog box, click the user account you want to add, click Add, and then click OK ". Click OK ". After adding the permission, you also need to log out of the normal user and log on again.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.