Wednesday, June 02, 2004
When using Microsoft Visual Studio .Net and the MICROSOFT OLEDB provider for Oracle then using Server Explorer you can typically see a number of database objects, and what Microsoft call a Database Diagram.
This functionality - in particular the Database Diagram functionality relies on the fact that the development environment creates the following objects in the schema to which you connect
It follows that you get various errors if the schema you are using does not have create table,create sequence and create procedure rights.
You don't get the same problems if you use the Oracle OLEDB provider, but you don't see so many objects either.
0 Comments
This functionality - in particular the Database Diagram functionality relies on the fact that the development environment creates the following objects in the schema to which you connect
OBJECT_NAME OBJECT_TYPE
------------------------------ ---------------
DT_ADDUSEROBJECT FUNCTION
DT_DROPUSEROBJECTBYID PROCEDURE
DT_SETPROPERTYBYID PROCEDURE
MICROSOFTDTPROPERTIES TABLE
MICROSOFTSEQDTPROPERTIES SEQUENCE
MICROSOFT_PK_DTPROPERTIES INDEX
It follows that you get various errors if the schema you are using does not have create table,create sequence and create procedure rights.
You don't get the same problems if you use the Oracle OLEDB provider, but you don't see so many objects either.
0 Comments:
Post a Comment
