Kbase P132676: Error 8186 when attempting to add a record in the _sysdbauth schema table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2008 |
|
Status: Unverified
SYMPTOM(s):
Error 8186 when attempting to add a record in the _sysdbauth schema table
Attempt to insert, update or delete a row in a schema table. (8186)
The query below is executed:
insert into pub."_Sysdbauth" ("_grantee", "_Dbaacc", "_Resacc") values ('progress', 'y', 'y');
Connecting with either the SQL-92 ODBC Driver or SQL-92 JDBC Driver
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.x
All Supported Operating Systems
CAUSE:
This is expected behavior. It is not possible to insert a record in the _sysdbauth schema table directly from an INSERT SQL query.
FIX:
In order to insert a record in the _sysdbauth, the following queries have to be executed:
GRANT DBA TO <user_name>;
GRANT RESOURCE TO <user_name>;
Those queries have to be executed by a user with DBA permission.