Advice : Security on Oracle - set role at application

Our company use VB as development tools and Oracle on Window NT as backend.

There is a security policy suggested by the menu 'Application Developer Guide' from Oracle. In order to prevent use ad hoc tool, such as SQL Plus, to access the database and perform destructive action, the default role should be non destructive or disable all role after logon. When user run application, application should issue 'set role' to give the right privileges to perform the task.

The idea is great, but how can I 'set role' through application? Yours comment is appreciate!

Best Regards,

Phyllis Wong
wphyllis_at_hk.linkage.net Received on Thu Jun 15 1995 - 00:00:00 CEST