PRB: Must Connect Using SA Account for VID to Have Options to Manipulate DB

ID: Q233990

The information in this article applies to:

SYMPTOMS

When connecting to a SQL server database with an account other than the database owner, you do not see any options in the data view to add or modify tables.


CAUSE

You have limited capabilities depending on your SQL permissions. You must be the database owner in order to create new tables or modify existing ones from the Data View within Visual InterDev.


RESOLUTION

Connect to the database using the database owner account in order to create and modify tables.


STATUS

This behavior is by design.

Additional query words: 


Keywords          : kbDatabase kbide kbSQLServ kbVisDBTools kbVisID600 kbDSupport 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: August 2, 1999