Performing Select and delete on User Tables

[sudipta]

Hi,

I am new to Progress.

I am trying to execute the following statements from SQL Explorer:

set schema 'arijit';
select * from arijit.ReceiptHeads;
delete from arijit.ReceiptHeads;

The output is as follows:

=== Statement 1. ===
set schema 'arijit';

=== Statement 2. ===
select * from arijit.ReceiptHeads;
=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
Errors 1.
=== Statement 3. ===
delete from arijit.ReceiptHeads;
=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
Errors 1.
Statements: 3; Updates 0; Rows 0; Errors: 2; Warnings: 0. (8926)

The tables are accesible when check using the Data Dictionary Tool.

Please someone guide.

 

[tamhas]

Are you sure the tables are owned by arijit? In most Progress DBs they are owned by PUB.

 

[sudipta]

yes table owner is pub, but i am getting the below error when doing any dml opration on "SAPMCTax" table.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20228
[JDBC Progress Driver]:Access denied(Authorisation failed) (7512)

I have 2 tables

1. In 1st the newly created table owned by pub is able to do insert/delete.

2. But in 2nd already existing table "SAPMCTax " I am not able to do select/insert/delete

TBL COL OWNER
-------------------------------- -------------------------------- --------------------------------
SAPMCTax AccCentreNo PUB
APMCTax FromDate PUB
SAPMCTax MCCode PUB
SAPMCTax SalesTaxRate PUB

please inform me the reason

 

[tamhas]

Have you done the security setup for SQL? I.e., something like http://www.oehive.org/node/954

 

[sudipta]

But I did not set any authentication. I am using windows authenticationonly. Plz upadate me. what i can do​

 

[plus_marca]

Hi.

SQL access to PROGRESS data is deny by default, unless you get connected to the DB using a DBA login.

To check DBA / Resource privileges in use, execute the following SQL
statement in the SQL explorer:
SELECT * FROM sysprogress.sysdbauth;

the above SQL statement will show you which users have DBA privileges.

You could try connecting with user sysprogress.

Once you are connected as a DBA you should grant the require privileges to any user you need.

Also you should read the SQL manual from the PROGRESS site.

 

[tamhas]

Did you look at the link I gave you? The details are specific to the use of EA, but the concepts and procedures apply to any SQL use. The only users who have authorization to start are sysprogress and the ID that created the database.