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 |
|
jimmy
Starting Member
9 Posts |
 Posted - 2003-06-09 : 21:14:26
|
| Hi, can we create synonym in sql server and how to create ?The reason is when a user access a table that he is not a dbohe need to user owner.tablename. Is there a way just refer tothe table without specifying the owner if you are not the dbo.Thanks for help |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-09 : 21:27:07
|
| If the owner is dbo, then you shouldn't need to. Otherwise, you have to specify the owner. There is no synonym in SQL Server.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-10 : 12:30:01
|
| Yeah, but isn't the owner reference faster (not that I do this myself)?Brett8-) |
|
|
|
jimmy
Starting Member
9 Posts |
Posted - 2003-06-11 : 03:14:04
|
| Hi, thanks all.If we assign with dbo owner, what are the previliges does theuser have ? they can drop the table also right ? |
|
|
|
|
|
|
Any synonym can create in sql server