TOracleDataset and user rights (grants)

[sergio7]

Hi,

i have a problem with TOracleDataset. In my application some users have a role with only select grants assigned. The OracleDataset component seems to not recognize this returning an updateable resul set. Is there a way to make the dataset read only if the user has only select rights granted, or is there a easy way to know the user rights on an datbase object ?

TIA

Sergio Sette

 

[Marco Kalter]

The TOracleDataSet does not look at the privileges of the updating table. The only way to accomplish this is to let the application explicitly check the privileges and set the ReadOnly properties.

------------------
Marco Kalter
Allround Automations