rights for new user
For a new programmer, we set up the SqlServer Desktop engine on a PC and installed Visual Studio. The DB uses Windows Authenication for access control. The database was populated using backup/restore from a the desktop engine on a different PC.
The programmer logs into the network using his own ID & password. In the Server Explorer window of VS, he can not create new objects (e.g. when right clicking on Views, the "add new view" option does not appear). However, if he opens the Enterprise Manager, he can create new views and functions, but these additions do not become visible in the VS Server Explorer. (It IS the same database; we verified it via making data changes.)
I'm sure this is all a rights problem, but I don't know how to fix it. We used Enterprise Manager to add his login id to the users list of the database, and to give all the rights we could see to add, but it didn't make any difference. He as admin rights to the PC.
Can you help? Please be as specific as possible. Saying "add foo rights" is not going to helm. If we could see how to add more rights, we would have tried it.
Eye
