Re: Permissions of Logins

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 10/20/04

  • Next message: bigp: "Re: MSDE installation rollback" 
    Date: Wed, 20 Oct 2004 19:21:49 +0200

    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
  • Next message: bigp: "Re: MSDE installation rollback"

    Relevant Pages