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 |
|
misterraj
Yak Posting Veteran
94 Posts |
 Posted - 2008-05-14 : 05:28:00
|
| hello, I have list of tables in a database where schema1 is attached. when ever i login thru windows authentication or any other user and if i run select * from schema1.table i get proper values.what i need is even if i login thru windows authentication i should be able to run the query without attaching the schemai.e., select * from table should work. i am not sure what permissions has to be given.pls advise. |
|
|
eralper
Yak Posting Veteran
66 Posts |
Posted - 2008-05-14 : 06:11:03
|
| You can map the login account to a user which owns database owner role-------------Eralperhttp://www.kodyaz.com |
 |
|
|
misterraj
Yak Posting Veteran
94 Posts |
Posted - 2008-05-14 : 09:19:07
|
| not too sure how to do! any more explanations pls. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 09:22:15
|
| Make that your default schema and make it owner as well. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 22:50:34
|
| Or change schema to dbo. |
|
|
|
misterraj
Yak Posting Veteran
94 Posts |
Posted - 2008-05-15 : 00:06:22
|
| iw ant both the users to access. can i attach two schemas ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:52:20
|
| No. If object owned by dbo, every one can access it with name only. |
|
|
|
|
|
|
tables and schema