Re: Permissions of Logins

anonymous_at_discussions.microsoft.com
Date: 10/22/04 

Date: Fri, 22 Oct 2004 07:00:04 -0700

Hi Andrea,

You aksed if the login is associated to a database user. I
don't really understand that. I thougth that the login is a
database user. I associated it with one database (the only
one where I checked the permit flag). Maybe I did something
wrong?

Thanks, rainer.

>-----Original Message-----
>hi Rainer,
>"Rainer Halanek" <anonymous@discussions.microsoft.com> ha
scritto nel
>messaggio news:03e001c4b697$37083c20$a401280a@phx.gbl
>> I made a new login for my database. In the database access
>> tab i only checked my database as permit and gave the login
>> no server roles. But when I log on to the SQL Server with
>> that login, I can see all Databases and their tables on the
>> server. Why is that?
>>
>
>if your login only is associated to 1 database users and
for only 1
>database, you should get
>err 916 Server user 'x' is not a valid user in database
'db_name'
>raised by Enterprise Manager...
>please verify the login is not member of a particular
server role
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
>DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE
2000 a visual
>interface)
>--------- remove DMO to reply
>
>.
>

Relevant Pages