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 |
|
Cmftes
Starting Member
2 Posts |
 Posted - 2004-08-31 : 04:06:19
|
| I am testing something in MS SQL Server 2000. I created new login account that use SQL Server Authentication with grant access. Through the wizrad I left blank box for role, and for permit in DB. So that login has neither no role, nor explicit access to any database.Thus, I connected using that login to SQL server (using Query Analyzer)and I can execute anything.That's somehow strange.How could this be possible?Should I be forbidden to do those things, because I am don't have any role, nor granted db?What's the default settings?Tnx for answers |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-08-31 : 04:15:46
|
| Check the access for the guest account, it may fall under that.If the login has a server-wide role, it can do anything that role is allowed to do.-------Moo. :) |
 |
|
|
Cmftes
Starting Member
2 Posts |
Posted - 2004-08-31 : 04:44:54
|
| u r rightI thought I deleted, but obviously not for all dbTnx!!! |
|
|
|
|
|
|
Confusuion about login without role