Insufficient privileges appears in oracle

Recently came into contact with ORACLE, the concept of this database is still quite good, in the learning process, encountered a lot of small problems. Perhaps the same hint means different solutions at different levels.

Insufficient privileges appears when I use create table chem_dict_hello as select * from USR_HXPG.chem_dict_hello;.

Scenario: when I use the administrator to create a new user, and then want to copy part of the table and data to the new user, the roles and permissions are set, and then use the above statement to indicate that the permissions are insufficient.

Baidu: most of them say that there is something wrong with the password file, or cache and reconnect.

My solution: my new user does not have the right to query the table, just give it. Although you can use toad's shortcut to copy data, you still have a little more understanding of permissions. Igrant all on USR_HXPGL.CHEM_DICT_CHEM_CASFIX to USR_YJD

. The permissions of the table include select, update,insert,delete, all.

Conclusion: this is the small problem encountered by the rookie on the road. In fact, it is also a matter of thinking.