How do I "Set Role" with Visual Interdev?

I am trying to connect to an Oracle DB using Visual Interdev6 for my web development. I am not familiar with Oracle, so please bear with me. I can connect to the DB fine and see all the tables when I am given full (XYZ)permissions (role?) to the DB. The Oracle DBA wants me to "Set Role" as in the statement "set role xyz_manager identified by xyz_manager" to define the proper permissions (role?) for the DB. I feel this statement should be in the global.asa file, but I have tried everything I can think of and I still get the error: "ADO error: ORA-01950: no privileges on tablespace 'USERS'". As a result, I cannot see the tables in the data view window to use with VI6. How and where do I "set role" from VI6? Thanks for your help!
Rod Received on Wed Jun 28 2000 - 00:00:00 CEST