Oracle appears insufficient privileges

Recently contacted Oracle, the idea of this database is very good, the learning process, encountered a lot of small problems. Perhaps the same hint, at different levels, means different solutions.

When I use the create table Chem_dict_hello as select * from Usr_hxpg.chem_dict_hello, there is a insufficient privileges.

Scenario: I used the administrator to create a new user, and then want to copy a portion of the table and data to the new user, the role and permissions set a bit, and then use the above statement, the prompt permission is insufficient.

Baidu: Most say the password file has a problem, or cache, reconnect.

My solution: That is, my new user does not have the query permission on the table, gave the good. Although you can use Toad to copy data quickly, or a bit more understanding of permissions. igrant all on USR_HXPGL. Chem_dict_chem_casfix to Usr_yjd

。 The permissions for the table are select, Update,insert,delete, all.

Summary: This is the rookie on the road encountered small problems. In fact, it is also a question of thinking.

This article is from the "one-stop solution" blog, so be sure to keep this source http://10725691.blog.51cto.com/10715691/1930155

Oracle appears insufficient privileges