Re: Default access for a login
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/28/05
- Next message: Christopher Pankhurst: "Re: Strange requirement for linked server"
- Previous message: Sue Hoegemeier: "Re: Changing Password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 27 Sep 2005 16:28:01 -0600
Yes they can connect. In terms of what they can execute
where, that depends.
If a login isn't assigned a database, they will access
databases under the guest account. If guest is in the
database, they have access to the database and whatever
public permissions have been set as well as whatever has
been explicitly granted to the guest user in that database.
Guest always exists in master and tempdb - you can't delete
the account from those databases.
-Sue
On Tue, 27 Sep 2005 14:19:01 -0700, "Radu"
<Radu@discussions.microsoft.com> wrote:
>Hi guys,
>
>I create a new login; let's say "aaa" with authentication "SQL Server
>Authentication" and no database access specified.
>
>Now... I'm able to connect to my SQL Server 2000 using Query Analyzer with
>this "aaa" login and read data/execute stored procedure even I didn't specify
>any level access. For me looks strange, I was expecting to access a database
>after I define a user and permisions using this login. Is this normal?
>
>
>
>Thanks!
- Next message: Christopher Pankhurst: "Re: Strange requirement for linked server"
- Previous message: Sue Hoegemeier: "Re: Changing Password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
