Checking for privileges

jpchausseau

Member²
(Maybe this is not the appropriate forum for this question. Sorry if this is the case.)

Could someone give me some hints on how to check for the user's privileges on a table linked to a TOracleDataSet?

Thanks,
Jean-Paul
 
Try

select privilege from user_tab_privs where
owner = :table_schnema and table_name = :table_name

if logged_in_user is schema owner, then table have all privileges

Best regards
smile.gif
 
Back
Top