What to do if Oracle has insufficient permissions

ORA-01031: Insufficient permissions problem

When the script is updated, an error is reported: ORA-01031: Insufficient permissions.

grant connect,resource,dba to cssy;

After empowering DBA, there is still this error.

Execute grant all privileges to cssy

to give any host permission to access data, and the problem is solved.

Oracle related introduction:

Oracle, the full name of Oracle Corporation (Oracle Software Systems Co., Ltd.), is the world's largest enterprise software company, headquartered in Redwood Beach, California, USA. Officially entered the Chinese market in 1989. In 2013, Oracle surpassed IBM and became the world's second largest software company after Microsoft.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of What to do if Oracle has insufficient permissions. For more information, please follow other related articles on the PHP Chinese website!