Granting DBA priviledges. Getting an error.

M

maploosh

New Member
I have a progress database where I am attempting to grant dba priviledges to a specific user. I am currently running Progress 9.1e. I have tried all sorts of different ways of granting this priviledge but am getting the following error message:

SQL Exception 1
SQLState = HY000
ErrorCode = 210017
[JDBC Progress Driver]: Failure to acquire exclusive schema lock for DDL operation (7872)

Has anybody ever encountered or solved this issue?
Thanks
Matt
 
Are you sure you're the only user (including batch processes) connected to the database at the moment your executing the GRANT statement?

Regards,

Casper
 
Casper,
No, there are other users on the system at the same time. I cannot figure out how to login in single user mode.
Thanks
Matt
 
Grant statement needs a schema lock on the entire schema, so no users should be having (unfinished) transactions at the time you issue the command.

See KB: P24790: http://tinyurl.com/oc7bf

Regards,

Casper.


maploosh said:
Casper,
No, there are other users on the system at the same time. I cannot figure out how to login in single user mode.
Thanks
Matt
Click to expand...
 
You must log in or register to reply here.
Back
Top