Re: How do I "Set Role" with Visual Interdev?

have the DBA/or you execute these command in SQL/PLUS (webuser -- is the user id and
  webrole -- is the role)
____start of script commands:

create role webrole NOT IDENTIFIED;

grant alter session, create session, connect, resource,

               exp_full_database, webrole to webuser;

grant alter session, create session, connect, resource,

               exp_full_database, webrole to webAdmin with Admin option;

commit;
______end of script commands:

B. Smith <nc_curious_at_hotmail.com> wrote in message news:nfy65.5130$Q7.139756_at_news-east.usenetserver.com...
> 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 Fri Jun 30 2000 - 00:00:00 CDT