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 CDT
