No DBA in database

[Craig Fry]

We recently added an odbcuser to the SQL authorization. Prior to that the
table was empty. There isn't a dba account. The only user in the table is the odbcuser we added and they aren't a dba. What backdoor/voodoo do I need to do to get back in?

Thanks

 

[Casper]

Create user "sysprogress" with password in data administration. Log in as sysprogress and you have DBA rights.

Normally the creator of the database is the default DBA user.

Regards,

Casper.

 

[Craig Fry]

So how do you create a user when you are not DBA?

 

[Casper]

Oh sorry,

I assumed you had access to the data adminstration or 4GL (ABL). With that you can create a user. If you don't have a license to do that, then you have to contact your software vendor. But I doubt if he will let you have DBA access to the database if you haven't got it already.

Regards,

Casper.

 

[Craig Fry]

No, I have access to both. How do you add a user without DBA permissions? You can't do that if you login without a username/password and there isn't a DBA account to login with.

The ONLY account is the odbcuser account which is NOT DBA.

 

[Casper]

You can create with 4GL (ABL) _user entry:

KB P7192: http://tinyurl.com/yospvr

HTH,

Casper.

 

[Craig Fry]

Perfect. Thanks.