Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-05 : 07:30:49
|
| Franklin writes "I am developing a VB application vs SQLServer 7.0(no SP), I grant all the privileges to the user of tests in the Database, but when I attempt to insert a row in one table of the database, SQLServer indicates me that the table doesn't exist.Almost of granting the privileges to the users one must create synonyms (?) for the tables so that they could be seen for all the users.Thank you" |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-12-05 : 08:56:31
|
| You may need to prefix the table name with its owner, as in if your user joem owned the table stuff you could reference it select * from joem.stuffDoes something like that help?-------Moo. |
 |
|
|
|
|
|
Exist the Synonyms in SQLServer