check if a user is a dba or not

W

weiwei

New Member
New to Progress, I'm creating a crystal report with connectection to progress db.

We created an ODBC user connecting to Progress database. we granted the user DBA rights.

But today when we test it, we can link the database, tables,but we cannot open the tables, it says failed odbc user authorization.

We are not sure what we did wrong, can I check somewhere it is a user with DBA rights?And what is the statement I should use?
I have progress client installed on my computer?



Thanks
 
weiwei said:
can I check somewhere it is a user with DBA rights?And what is the statement I should use?
Click to expand...

ID: P93181
Title: "What is the meaning of the columns in SYSDBAUTH table?"

http://tinyurl.com/72q29


You need something like:
select * from sysprogress.sysdbauth

If you have problems accessing this information, search the progress knowledgebase on 'sysdbauth'.
There are a few relevant entries.

I haven't used this stuff before, so may not be of much help...
 
For the rest of your post, if you supply your exact environment and error message details, somebody may be able to help.

btw. It goes without saying: don't mess about with the sys admin privileges unless you know what you're doing.

Lee
 
dba questions

Thank you for all. We are K12 enviroment using application SKyward which is using Progress database.

I use odbc connection Access database find out in the sysdbauth I cannot find that user name we thought we have created.

But we did create it, and we test it from ODBC it can connect the database, choose tables, and fields but we just can not open the tables.

For creating the user requires us to ask everybody off, which is hard in our enviroment, we try to find out and debug why we made the mistakes.

Here is what we did:
Creating the User Name and Password in SQL
  • From the Start Menu, go to Programs-PROGRESS-SQL Explorer
  • Go to File, Connect.
  • Select Basic FORMAT tab.
  • Enter Host Name (see step 8 above)
  • Enter Service Name (see step 9 above)
  • Enter Database: Skyward.
  • Enter User Name: sysprogress
  • Password: x
  • Click OK.
  • In the white box at the top of the screen type the following:
· On the first line type: Create user ‘username’, ‘password’; (where username and password are unique names, not previously used in PaC.)
· On the second line type: Grant DBA to 'username';
· On the third line type: Commit;
  • Click on the Lightning button at the top
  • Choose File, Disconnect.
  • Click File, Connect.
  • Enter the new user name and password you just created to test the connection.
 
You must log in or register to reply here.
Back
Top